Adding new products

How to add products from a file and combine adding with updating.

Got a file from a wholesaler or an export from another store? Use one of two goals: Add new products from a file or Add new and update existing.

What you need first

A file with a name column and an SKU or ID column. See Prepare a CSV or Excel file.

How the goals differ

Add new products from a file: a product that's already in the store goes on the list with the error “The product already exists. Choose update.”.
Add new and update existing: products found by SKU or ID are updated, and missing ones are added.

Steps

Go to Import and choose a goal.
Upload the file.
Check that Product name and SKU are matched.
Answer the variations question.
Click Check what changes.
Check the product counts and the Categories from the file list.
Click the save button.

After saving, open a product with View in store.

Limits

Missing categories are created when you save, not during the dry run.
With the combined goal, updates touch only matched columns, and an empty cell clears the field.
You can match an ID only when rows aren't combined into variations.

Common problems

Several products in your store share the same SKU? Import won't guess which one to change. Fix the SKU in the store and retry the item.

Can't find the answer? Write to hello@getwoomate.com or request free onboarding help.