Start with a consistent separator

Export from the supplier system as CSV UTF-8 when possible. Columncraft detects comma, semicolon, tab or pipe separators. Put a field containing the separator or a line break in double quotes. Inside a quoted field, a literal quotation mark is written twice. A wide row may indicate an unquoted comma in a description.

Choose the source number format

A value such as 1,234 can mean one thousand two hundred thirty-four or just over one unit. Select the supplier’s decimal convention in Review and fix. If a CSV mixes number formats in a single price column, standardize the values first. Use one currency matching your store. The converter performs no exchange-rate conversion.

Test the draft import

Download the CSV after resolving blocking issues. In Shopify Admin, open Products and use Import. Start with a small file of new handles, review the preview and check the overwrite setting before proceeding. Shopify validates store-specific constraints and fetches images at import time.

Reference Shopify’s product import instructions.