Update from a spreadsheet
Match a new price list to the products already in your store and change only the fields you choose.
Starter and upPrices and stock change. Update takes your supplier's latest spreadsheet, matches each row to a product that is already live in Shopify, shows you every difference, and writes only the ones you tick. You can undo it afterwards.
#What you can update
A spreadsheet can change any of these fields on a live product or variant:
- Sell price and Compare-at price
- Cost per item, which is kept separate and never becomes the sell price
- Inventory
- Title, Description, Vendor, Product type and Tags
- Product and variant metafields
The file needs at least one way to find each product (SKU, barcode or title) and at least one field to change.
#Run an update
Start a new update
Open Products, choose Open update on the Update card, then New update.
Drop your spreadsheet
On Select a spreadsheet, drop a
.csv,.tsv,.xlsxor.xlsfile of up to 20 MB. Rows are matched to your store by SKU, barcode or product title. For a workbook with several tabs, pick one.Check the columns
Loger remembers a mapping from a file with the same headers. Otherwise it reads the columns itself and, if needed, asks the AI to help or asks you a few questions. On Check columns you can change what each column means, or choose Let AI map these columns. Choose Continue to preview.
Review the changes
Review changes lists every product, with the change to each field. Tick the rows you want. No row is ticked for you.
Apply
Choose Update N products. When it finishes you see Updated N products and can Update more products or open the changes as a CSV.
#How rows are matched
Loger looks for a product by SKU first, then barcode, then title. Title matches need to be very close. When a row cannot be matched with confidence, it appears under unmatched rows with up to three suggestions, and Use this match accepts one.
A bare Price column next to a cost column is ambiguous, so Loger asks: "Is this what customers pay?" You answer It's the sell price or It's the cost per item.
#Safety checks
Before you apply, Loger checks the changes and warns you about anything risky:
- A zero or negative price, or negative stock, cannot be applied. The update button is disabled until it is fixed.
- A price that more than doubles, or drops by more than 40%.
- A compare-at price that is not above the price.
- Duplicate rows in your file.
If a value changed in Shopify after you made the preview, Loger leaves it alone, and tells you how many fields it skipped, so it never overwrites an edit made in between.
#Limits
| Limit | Value |
|---|---|
| File size | 20 MB, one file |
| Rows matched per file | 5,000 |
| Products per update | 1,000. Above that the button is disabled and you Apply in batches. |
#Undo an update
Every update appears under Recent updates with its status (Applied, Partial or Reverted). Choose Revert to restore the previous values. See Rollback and history for what is restored and which plans can go back further than the latest update.