All things Shopify and commerce
He everyone!
I'm planning to update a website of a current Shopify user. I've been working on a separate dev site to set everything up.
I know of the frustrating part of needing to manually update navigation and collection pages, but I'm curious to know how I import only certain data of the products.
Since I exported the original list from the live site and imported into my dev account, I know that if I import the updated products back they will overwrite the current ones. This is fine and basically what I want, but I wonder if I only add certain columns in the CSV. Will missing columns be erased from the products? (example: I want to only update the images and tags, so if I remove the "inventory" column, will the inventory be blank in the overwritten product?)
Thank you in advance!
Solved! Go to the solution
This is an accepted solution.
Hello there,
Yes, you can add only certain columns in CSV and import in Shopify. No need to include all the columns and it will affect only those columns which are in your CSV, don't worry about the other data and content.
but, please make sure you will take a backup by export CSV for your all products. In can if you miss something then you can import your backup CSV.
Thank you,
Tejas
This is an accepted solution.
Hello there,
Yes, you can add only certain columns in CSV and import in Shopify. No need to include all the columns and it will affect only those columns which are in your CSV, don't worry about the other data and content.
but, please make sure you will take a backup by export CSV for your all products. In can if you miss something then you can import your backup CSV.
Thank you,
Tejas
Thanks Tejas!
I am sharing my notes on import product data to Shopify stores on this entrance of my blog
I hope they will be useful to everyone, thank you
Regards
To clarify. Empty ( non relevent ) columns can be deleted from the csv prior to import ?
Yes, if you delete those columns, they won't be imported and the data that exists in the product won't change.
Hi, Amanada.
Obviously I'm about 3 years late for this info to help you... but I thought I would put this info here all the same, as it might help someone else.
I just got off the phone with support about the exact issue. Here is what I learned:
--It appears that the only absolute required columns are the "Handle" and the "Title" columns, along with whichever columns you wish to update. Leaving columns/cells blank will overwrite existing data fields with blank data, so it's good to only keep the columns you want to overwrite your existing data.
--If you have variants, then the "Option1 Name", "Option1 Value" Columns are also required, (As well as "Option2 Name", "Option2 Value, and "Option3 Name", "Option3 Value" columns, if they are used/applicable.) Without these columns (if variants are present), the data will not be updated, as Shopify cannot make a match of existing products.
--The final column, "Status" is not required, but if it is not included, then Shopify defaults products imported to "Active". Therefore, if you want products coming in as drafted, you must include this column as well, with the "draft" value.
--Regarding the "Variant SKU" column, if used... Shopify will allow you to import duplicate Variant SKUs, however they will be flagged as duplicate within Shopify. The same as if you had manually entered a duplicate Variant SKU.
Hope this helps someone!
Yes, you can add only certain columns in CSV and import in Shopify. No need to include all the columns and it will affect only those columns which are in your CSV, don't worry about the other data and content.
If you wish to automatically update only some columns (eg. pricing, inventory), you can achieve that using the Moose Sync app.
Portrait of Stephen positioned next to an image of planet Earth, with the Stephen's World ...
By JasonH Mar 18, 2024Digital marketers and app developers have tracked activity in apps and websites for yea...
By Ollie Mar 13, 2024February was an exciting month with Shopify Editions, informative webinars, and more! F...
By JasonH Mar 7, 2024