If you have installed Prisync’s Shopify App, you should import your products directly from Shopify. For detailed steps, refer to our Shopify article for product import and the bulk URL import article to add links.
To add new products and their URLs to Prisync in bulk, you’ll need to prepare your data in an Excel (.xlsx) file.
First, simply click the Import button on the Products page or the Data Management option on the sidebar.
Then, select Product Source.
On the next page, choose the 1st option: Upload an Excel to add new products in bulk.
The steps below will help you complete the import:
A. How to Download the Sample Excel File?
You can download the sample template from the Add New Products section (Account Login Required).
B. How to Fill the Import File?
In the template, you will find predefined columns for product information: Name, Product Code, Barcode, Brand, Category, Product Cost, Additional Cost, and Your Own URL.
When adding new products, please keep the following in mind:
Name, Brand, and Category fields are mandatory. If any of the fields are left blank, the product will not be imported.
If you do not have information for Brand and/or Category, you can enter them as "No Brand" and "No Category".
Products with the same Name, Brand, and Category are considered duplicates and will not be imported.
Products that already exist in your Prisync account will not be re-imported.
Adding Your Own URL will allow us to calculate your Price Position and Index.
The URL should lead to a specific product page with visible price information. Search or listing pages don't qualify.
C. Mapping Properties
Now it’s time to map the columns in your file to Prisync’s properties. The properties are:
Name
Product Code
Brand
Category
Product Cost
Additional Cost
Tags
Your Own URL
You can rename the columns in your template, as long as each one is mapped to the correct Prisync property; otherwise, it will be ignored.
After completing this final step, click the Complete Import button located at the bottom right corner of the page. Your file should then be imported into your account.
D. Import Status & Errors/Warnings File
Once the process is complete, you’ll be able to view their statuses. There are three possible statuses:
Completed successfully
Partial import (partial success)
Canceled
You will also see a summary of your import, including the number of products added and any errors encountered. From the Actions dropdown, you can download the import file, as well as any errors/warnings files.