Who this is for
Owner or merchandiser of a Shopify store who imported a product spreadsheet and found existing products changed, blanked or stripped of variants.
An import finished, then product descriptions, prices, vendors or variants on products you did not mean to change were replaced or emptied.
The result
For the products you agree were affected, a test store loaded with the damaged products first differs from a reference you choose, and after a corrective file is imported a fresh export matches that reference in the agreed columns and variants, with no differences.
What is included
- Comparing three files you send: the export from before the import, the file that was imported and a fresh export of the current products
- Finding which products, columns and variants were replaced, blanked or removed, and why the import did it
- A corrective product file limited to the agreed handles and columns
- A test-store check: load the test store with the damaged products, show it differs from the reference, import the corrective file and show the differences are gone; then a short import guide for your live store
You receive
- The corrective file in Shopify import format, UTF-8, with the exact headers the import expects
- A row-by-row change report: product, column, value found, value restored
- The before and after comparison from the test store: the damaged state against the reference, then the restored state against the reference
- A one-page explanation of what the import did and how to avoid repeating it
- Import steps for your live store, including a fresh backup export first, and how to reverse it
What is not included
- Importing into your live store; you or your administrator run that import
- Restoring the old variant IDs, which a spreadsheet cannot do once option values were changed
- Stock counts for stores with more than one location
- Rebuilding data that no reference file or source system holds
- Customers, orders, discounts, collections membership, apps or theme display problems
What we need from you first
- Which products and columns look wrong, with two or three public product links
- When the import ran, and whether the overwrite option was ticked if you remember
- Whether you have an export from before the import, and its approximate date
- How many products were in the imported file and how many look affected
- Whether the store has more than one stock location
Never send passwords, keys, customer records or confidential code in the first enquiry. Secure handover is agreed after scoping.
How we check it is done
- Before the corrective import, the test store seeded from the current export differs from the reference in the damaged columns and variants, and those differences match the damage on the live store
- After the corrective import on the test store, a fresh export matches the reference in every agreed column for every agreed product
- Each corrected product has the reference number of variants, with the same option names, option values, SKUs and prices
- The corrective file contains only the agreed handles and columns, so no other product changes
- The corrective file imports on the test store with no row errors
You review the comparison and sign off on the test-store result before payment. Importing into your live store is a separate step you take.
When we would stop or decline
- No reference exists for the damaged fields and the source system cannot supply one
- Subscription, bundle or inventory apps depend on the old variant IDs and cannot be re-pointed; we explain and quote that part separately
- The products were also edited by hand after the import so there is no single right value, and nobody can choose
- The damage is in orders, customers or payments rather than product data
Questions
Will you import the file into my live store?
No. You run the live import with our steps, after exporting your live products first.
Can you bring back the old variant IDs?
No. A file cannot restore IDs Shopify discarded when option values changed. We list the products affected so an app vendor can re-link them.
What if I never exported before the import?
We need some reference for the right values, such as a supplier file or an older export. Without one this fixed job does not fit.
Price and terms
From £295 · untested offer price. After the agreed checks pass and you sign off; no payment before sign-off.
This is a new service with no published client results. The price is a starting point we have not yet tested with buyers. Nothing is ordered or charged by the enquiry. The full specification is on the Synthetic Industry catalogue.