To copy prices and options for 289 products in our spreadsheet from an external sites product list.
Column A = Name of product
Column B = Model
Column C = Price
Column D,E, Etc = Options
We wish to add multiple product option values for a list of products on a spreadsheet.
Each product option must be separated by a | (pipe). For example, if we are importing Size options, and so if the product in the CSV file has two sizes, small and large, the value in that productâ€™s rowâ€™s size column would contain:
However, we also wish to import a quantity and additional price for each option value, to do this we need to create a : (colon) separated list for each option value.
For example, if we are importing a product with 2 size options, small and large, and each has a quantity of 999, additional price of +[url removed, login to view], the Size column in the CSV file would look like:
small:999:[url removed, login to view]|large:999:[url removed, login to view]
(There are no spaces in this list and all product option will have a quantity of 999 so this is the same for each product option)
The content for the spreadsheet will be taken from an external online shop for which we have no access apart from through an internet browser. (We will supply the URL to you privately)
To get the information required simply copy the name of the product from our csv into the search bar on the home page of the external site and navigate to the product on the site.
Then take the information directly from that product.
We will supply a sample CSV with the format and the list of our products we need the data for.