Import your Shopify products into the store

Imports brings your catalogue over from Shopify. Upload the products CSV that Shopify exports, and Coritan creates the products, variants, prices, images and stock counts in it. Check the file first: a check reads every row and reports what an import would do, without writing anything.

• You need the Admin or Owner role to upload a file. Every member can open Imports and read its reports.
• In your Shopify admin, open Products, choose Export, and save the CSV file. The file can be up to 10 MB and 5,000 rows. A spreadsheet file, such as one saved as .xlsx, is refused.
• The store must sell in the currency of the prices. Add it under Store in Settings first.
• To import stock counts, the store needs a stock location that is turned on, as Add a stock location describes.

1. In the dashboard, open the organization, then Commerce, then Imports.
2. On the Import from Shopify card, under Products CSV, select Choose a CSV file… and choose the file.
3. Under What to do, keep Check it first.
4. Under Products the store already has, choose Update them or Leave them as they are.
5. Under Prices are in, choose the currency of the prices. Shopify's export has no currency column.
6. Under Stock counts are for, choose the location that the stock counts belong to. It starts at the store's default location.
7. Select Check the file.

The check's report opens and follows the check until it finishes. What an import would do gives the counts, and Rows it could not use lists the rows an import would skip. The report says Nothing was written.

After a check in the same session, select Import this file on the check's report. It imports the same file with the same settings.

Otherwise:

1. On the Import from Shopify card, choose the file and the settings as for a check.
2. Under What to do, choose Import it.
3. Select Import the file.

The import writes the products in batches, and its report shows the progress. You can leave the page while it runs. One import runs at a time: while one is running, the card shows its progress, and you can send the next file once it finishes.

• Rows that share a Handle are one product. The first row holds the product and its first variant, and the rows after it add variants or images.
• With Update them, a product whose handle the store already has is updated. A variant matches the store's by SKU, then by its option values, and a variant the file does not mention is left alone. A blank cell keeps what the store has, except that a blank Variant Inventory Tracker turns off stock tracking for the variant, as it does in Shopify.
• With Leave them as they are, those products are skipped, and only products with a new handle are created.
• A product takes its status from the Status column, or from Published. Without either column, a new product is a draft.
• Variant Inventory Qty sets the stock count at the location you chose.
• Product Category becomes a category that the storefront does not show.
• Images stay at the addresses in the file, which must start with https://. The store links them without copying them, as Add images explains.

The Imports card lists every import, newest first, with its File, Status, what it did to Products, the Rows with problems and when it was Uploaded. Check only marks a check. Select an import to open its report.

The report's counts are under What it did, or So far while it runs: Products created, Products updated, Products skipped, Variants created, Variants updated, Images added, Stock counts set and Categories created.

Rows it could not use gives each skipped row's number in the file, its Handle and the Problem. The rest of the file still imports, and a product with no usable variant row is skipped whole. When the list is long, search it by row, handle or problem, and select Download as CSV to fix the rows in a spreadsheet.

• The imported products appear in Products, priced in the currency you chose, with their stock counts in Inventory.
• A check changes nothing in the store.

Check the file or Import the file cannot be selected

Another import is running. Wait for it to finish, or select See its progress to follow it.

The card says Could not start the import

Another import started first, or the file was refused, and the alert gives the reason. See that import opens the import that is running.

The file is refused

It is over 10 MB or 5,000 rows, empty, a spreadsheet file rather than CSV, or not Shopify's product export, such as a file without a Handle column. Export fewer products at a time, or save the file as CSV.

The report says The import stopped

The alert gives the reason. The batches it finished stay imported, so send the file again to import the rest.

Imported products are not on the storefront

The file had no Status or Published column, so the new products are drafts. Publish them in Products.

Stock counts were not imported

The store had no stock location turned on, and Stock counts are for said No location. Add a stock location, then import the file again.

Import this file is missing from a check's report

The dashboard forgets the file when you reload the page. Select Upload the file, then choose the file again with Import it.

The report says No such import

The link points to an import this store does not have. Select All imports to go back to the list.

• Add and edit your store's products
• Track stock and stock locations
• Change your store's settings

POST https://api.coritan.com/api/v1/orgs/{org_slug}/commerce/imports takes the file as the multipart field file, with mode (upsert or create_only), currency_code, location_id, and dry_run=true for a check. It answers 202 with the queued import. GET /commerce/imports/{import_id} follows it, and GET /commerce/imports lists the store's imports. Import products from Shopify has the details.

curl -X POST "https://api.coritan.com/api/v1/orgs/acme/commerce/imports?dry_run=true&currency_code=EUR" \
  -H "Authorization: Bearer $CORITAN_TOKEN" \
  -F "file=@products_export.csv"