Title: Shopify Showing Incorrect Product Count on Import
Post:
Hi everyone,
I’m encountering an issue with product imports in Shopify. I currently have 27 products in my store.
Here’s what happened:
-
I exported my product list (CSV format) to make some changes.
-
After making edits, I tried re-uploading the updated file. Shopify then showed that I would be uploading 38 products, which doesn’t make sense.
-
As a test, I tried re-uploading the unmodified export file—the same one I downloaded without any changes. Even then, it said I would be uploading 38 products instead of 27.
Has anyone experienced this before? I want to make sure I don’t accidentally duplicate or mess up my product listings.
Here are my main questions:
- Is there a way to back up my store (products, collections, settings, etc.) before I try importing again?
- How can I test or troubleshoot this issue to ensure that the product count and data remain accurate?
I’d really appreciate any advice or insights!
Thanks!
Is that count including product-variants.
Or more importantly how many rows are in the actual CSV.
There are backup apps on the app store or automation apps like mechanic to export product data.
https://tasks.mechanic.dev/?q=export%20product
There are around 1,300 lines in the sheet, so it doesn’t seem like it.
Additionally, I’m worried if those back up apps use similar methods, it won’t restore correctly.
The big issue is that if I do anything, it’s on the live store
Something was probably changed in the CSV that is making old products/variants read as if they are new items.
Generally those apps would use the api to restore.
Remove your own actions as possible cause:
- I exported my product list (CSV format) to make some changes.
- re-uploading the unmodified export file
I get you tried a direct export/reimport without changing anything but triple check that in step #3 you didn’t open the file, save over the file or some other tool modified the file.
Try downloading/reuploading in different browser or different computer to rule out browser cache or admin cache issues are reshowing the changed file and not the presumed clean file.
If you have a backup CSV before all of this check that for it’s row count.
Then if still fails contact shopify support
https://help.shopify.com/en/support/topic-select/login-issue/contact/chat
To avoid future uncertainty setup validations in excel/gsheets etc to check data etc, and or services to monitor the frontend or product feeds for changes.
That’s fair to think, but I’ve even tried importing the freshly exported
file and it still is showing this information. Wouldn’t the unchanged
export from the store show the same information as what the store already
has (27 products, 1300 sku’s)?
Is the product view UI really showing all products and variants.
Is the CSV feedback showing products and variants, etc
Ignore the UI, what is in the CSV, are there really 1,300 skus or 624 skus.
That is your source of truth and that is what you should build verification and understanding around.
If you think there are new/missing products you should figure out how to identify those products in the CSV.
Digging deeper into this would be job.
Just go through the troubleshooting steps, build verification into your CSV process, or contact support for clarification or bug reports.
Both the CSV and the Product UI show the correct information. 27 Products, 1300 SKU’s. Counted myself the number of products and added up the variants.
It’s the CSV feedback that’s incorrect which is what is troubling. I’ve contacted Support and unfortunately, they informed me they are of no help when it comes to product importing and CSV verification.
When googling this questions, I saw other people online also experiencing similar issues but to no avail. There were also no solutions posted, hence why I posted one myself on the official community forms.
A clean export / import of the data within Shopify should mean the product and SKU’s are the same in the Product UI as the CSV feedback but that differs.
This must be a bug within Shopify, correct? If I haven’t changed anything within the export of the products and it’s differing when I reimport it, there must be something off. If this is a bug, what options are available to me?
