Hello,
We have a website via shopify, we have suppliers that supply us with products to put on our website and we get a percentage. Suppliers change their prices alot, so CSV files are going to be important to keep updated. Our suppliers have their own CSV Files that we could technically use. But some of the products on their CSV Files we do not have on our website. I would delete the ones that we don’t supply but there is ALOT of products. If i import the CSV Files as it is, with the products that we don’t have on our website, will it just ignore the ones that we don’t have an SKU for?
Hope this makes sense
If your supplier provides a CSV file that follows Shopify’s product import format, then most likely redundant products supplied in that file will be imported as well.
It’s best to ensure the CSV file includes the most accurate data!
https://help.shopify.com/en/manual/products/import-export/import-products#importing-products-with-a-csv-file
2 Likes
Hi, @GDirect !
Welcome to the Shopify Community! To confirm what @Nick_Marketing mentioned, if you import products using a CSV file, any products with a new product handle will be added to your products list in the Shopify admin. We use product handles as our unique identifier for each product. The CSV import will not ignore products that don’t have a matching SKU within your admin, any new products will be imported as long as they have a new product handle. As well, any products you import via CSV file that have a matching product handle to one that already exists in your admin will be overwritten.
I recommend reading through our help document on using CSV files as it explains how importing products through CSV works in detail including a breakdown of each column. As a reminder, you must use our CSV format in order to import your products successfully.
My suggestion is to use a CSV editor such as Google Sheets to eliminate the products from your suppliers CSV that you will not be selling. From there, make sure you format your CSV into the proper format for importing with Shopify - here is our template. This way, you will only import the products you will be selling.
Let us know how this goes, and if you have any further questions!
2 Likes
Hello, I appreciate your reply. I’m thinking it may be easier to just download a CSV File with all of my products and increase the price on there and reupload?
I’m not sure if you’re advanced on excel, but do you know if its possible to increase a bulk of numbers on excel (By highlighting the whole of the price section) and somehow increasing the number by a certain percentage?
Thank you
That sounds like the easiest solution if the main goal is to increase all product prices by a certain percentage. By exporting the product CSV first, and the increasing the price through Excel, and then re-importing this same spreadsheet, you won’t add any new products and will only overwrite the product price, since all other information will remain the same.
Although this is outside our scope of support, I can tell you that this is possible through Excel and Google Sheets. Here is Microsoft’s tutorial on how to increase or decrease a value by a percentage in Excel. Once you have increased the values, you can then copy and paste the new values into the variant price column. Make sure to not modify the formatting of the columns, otherwise your import won’t be successful.
You can always start off with trying this for one or two products to practice first! Let us know how this goes.
Just so you know, there is also the bulk editor available for editing products within the Shopify admin. It is not possible to enter formulas in the bulk editor however, so in your case, using Excel will likely be the fastest option.