Once you've prepared the manual sheets as instructed (read more below), please send them to [email protected], and we'll take care of importing the data for you.
How to create a file for importing vendors' quantities
In PriceShape, you can bulk import vendors quanities to your product list. To do this, we need a file with three columns containing the required data.
Important Information
Please note that the values entered in the Quantity column will be used in the vendor price calculation. The quantity will divide the vendor price accordingly.
You can read more about how the calculation works in the related article here.
Required columns
Column A: upi
Header name: upi
The UPI (Unique Product Identifier) is used to uniquely identify each product and ensures that tags are applied to the correct product.
Read more about UPI here.
Column B: domain
Header name: domain
Enter the vendor’s domain.
This determines which vendor the quantity should be assigned to.
Column c: quantity
Header name: quantity
Enter the quantity value that should be applied to the specified vendor and product.
If you need to assign quantities to multiple vendors for the same product:
Duplicate the UPI in a new row
Add the relevant domain and quantity for each additional vendor
Each vendor must be added on a separate row.
Template:
You can use the following template to get started: https://docs.google.com/spreadsheets/d/1emNn2EJV_TfUVgO8uI_NVQL5kHABsLZv_aEgoxi1dZw/edit?gid=0#gid=0