If I need to update 2 values for my products (replace descriptions with html descriptions) how should I structure the csv?
Do I need to include ALL the info again with the new description or just the fields with new values?
My worry is that I click "overwrite existing" only add handle (its the key right?) and description and end up with 14000 blank products. I don't want to risk duplicates either as I then have to empty entire DB and start over as it's to many products to screen manually.
Also, any way to get a count in Shopify. If I import 3400 products from a single brand, I want to know when I search in Shopify that I find 3400 products. Can't find a count anywhere.
Hope my question makes sense and sorry if it's basic.
This is Max from the Shopify Team.
It sounds like what you're looking for is a way to gain some confidence in uploading new details to your shop, and using CSVs. In that case, I'd suggest looking over a few resources on CSVs (I'll link them below) and I'd also recommend working with some smaller sample sizes than 3400 products. Edit a section of your CSV to contain only a manageable amount of products that you can upload and review directly. That way you can troubleshoot and finesse things before uploading larger files!
To edit two values, it might be easiest to export a current CSV file and then tweak the relevant columns before choosing to "overwrite" the upload. A CSV with blanks would not be read by our system (so, ALL the info would be needed).
An alternate way to make changes to your inventory would be to use the bulk editing feature. This allows you to tweak sections within the admin, rather than editing a CSV externally. Depending on the values you're looking to change, this might be a good option!
Lastly, counting products depends on how you have these items organized. Are there any keywords in product titles, tags, or vendors you could search for? I'd suggest looking at the search and filter options on your Products page to see how you can look up products easily. I'd also advise reviewing the Products CSV file format.
That's a lot of information to review and take in, so, please let us know if you need some more help or clarification on anything in particular!
Manually importing products takes time and not to mention save space. I am using Importify app to import unlimited products to my store, and it gives me the option to get products from 40+ supplier stores other than AliExpress. I get products from Etsy and Wonify and find US suppliers for faster shipping. And when I started making a sales, I used Importify to easily fulfill orders on selected sites.
I can vouch that updating products has been a sore topic in Shopify unless you use an app like excelify etc.
We were able (after about 33 hours of work. Seriously.) to upload all the products and make changes as well to the images or descriptions by utilizing the Shopify api.
That's right. There are a few great apps to achieve that, and without apps, it will cost you a few thousand dollars. We've launched a new solution to achieve importing and updating inventory from different suppliers. Many merchants working with a PIM system and using custom CSV files and custom data formats use Moose Sync.
Bulk updates done wrong can wreak havoc on your store. When our clients integrate their Shopify data with Airtable they are usually trying to solve this exact problem, as Airtable's spreadsheet/database design automatically prevents your from messing up your data. And no more wrestling with CSVs that lack formatting and safeguards. Take a look at our guide on how to bulk update your Shopify data .
Ideally you would require a PIM to handle all your product data and integrate with Shopify. PIM would also allow you to work with other solutions like CRM and ERP. This will eventually allow you to ensure that all the systems are having a similar product data source. See more information on "What is PIM" to know more about PIM and how it integrates with your systems.