I am setting up a new Shopify site and connecting it to Xero using S&B. I currently have no products in Shopify and want to use S&B to import several thousand SKUs into S&B (and let S&B push them to Shopify). I downloaded and filled in the values from the S&B template file but there are many things that seem to be ‘missing’ (both fields shown in S&B as well as many fields available in Shopify). For examples, is there a way to upload via csv additional data fields such as (product url, total stock, allocated stock, available stock) etc?
Also, I was not able to alter the ‘Supplier’ field when uploading a csv. I first created the supplier manually in S&B and then uploaded a csv with that supplier name in the column but the field remained blank for some reason. Also, the weight field was not filled in as well. Not sure what I did wrong. I checked the csv file by opening it in note pad and the weight shows there.
Also, is there a way to ‘upload’ images via csv by pointing to a url in which they exist?
Lastly, when I was experimenting with all of this, I uploaded the csv times multiple times (making changes to things each time). I noticed that the products were duplicated in S&B every time I uploaded the file. While I could easily delete these test products now, I am concerned that this would be a huge problem down the track when there are thousands of live products in the system. Why is the system allowing the import of identical SKUs that are already in the database?
If these things are not possible to do via csv, is there a third party Shopify plug-in which you may recommend?
thank you and regards, Andrew