So I don't think this can be done... but then I am just a lowly novice when it comes to access. Is there one out there that can solve this seemingly impossible challenge?
So I am trying to upload our products on to shopify. After a lot of effort I have come so close, but there is one last obstacle that I have not been able to find a time efficient solution to.
We have over 12,000 products in the database from our main supplier. They post a stock feed online every day, which I want to download, put into our database and be able to generate the upload csv for shopify.
The problem:
All of the variations of a product in our database, have their own row, and own unique product code.
In the upload template for shopify, (found at help.shopify.com/en/manual/products/import-export/using-csv#get-a-sample-csv-file with a guide for the table), They have a separate row for the parent product, and then all the variants have the same 'handle' as the parent.
Fields that need to be filled in on the parent, but left blank in the variants:
Title
Tags
Body (HTML)
Vendor
I have provided a copy of our database, with some sample data. As you can see the variants have been done differently depending on brand/manufacturer.
As far as I can see this will need to be done manually for each record... I'm really hoping that there is a genius out there that can suggest a better/quicker way of doing it.
So I am trying to upload our products on to shopify. After a lot of effort I have come so close, but there is one last obstacle that I have not been able to find a time efficient solution to.
We have over 12,000 products in the database from our main supplier. They post a stock feed online every day, which I want to download, put into our database and be able to generate the upload csv for shopify.
The problem:
All of the variations of a product in our database, have their own row, and own unique product code.
In the upload template for shopify, (found at help.shopify.com/en/manual/products/import-export/using-csv#get-a-sample-csv-file with a guide for the table), They have a separate row for the parent product, and then all the variants have the same 'handle' as the parent.
Fields that need to be filled in on the parent, but left blank in the variants:
Title
Tags
Body (HTML)
Vendor
I have provided a copy of our database, with some sample data. As you can see the variants have been done differently depending on brand/manufacturer.
As far as I can see this will need to be done manually for each record... I'm really hoping that there is a genius out there that can suggest a better/quicker way of doing it.