Bulk Import & Export

SKU Manager supports CSV-based import and export for products, inventory levels, customers, and orders. Use bulk operations when setting up a new catalogue, migrating from another system, or performing data corrections.

Importing Products

To upload a batch of products and variants:

1. Go to Products → Import
2. Click Download Template to get the CSV with all required and optional columns
3. Fill in the template:
   • Required: product_name, variant_sku, variant_title
   • Optional: barcode, description, category, weight, price, image_url, reorder_point
4. Upload your filled CSV and click Preview
5. Review the preview — warnings flag formatting issues; errors block import
6. Click Import to apply

Matching behaviour: rows are matched by variant_sku. A matching SKU updates the existing variant; a new SKU creates a new variant. Product-level records are matched by product_name.

Importing Inventory Levels

To set initial stock quantities or bulk-adjust existing levels:

1. Open the inventory import tool from the Warehouse area
2. Download the inventory CSV template
3. Fill in variant_sku, warehouse_name, location_code, and quantity
4. Upload and preview — mismatched SKUs or unknown warehouse names are flagged
5. Click Apply to update stock levels

All imported inventory adjustments are logged in the audit history with the reason "CSV import".

Exporting Products

1. Go to Products → Export
2. Choose which columns to include, or use the default full export
3. Optionally filter by category, status, or warehouse
4. Click Export — a CSV downloads to your browser

Exports include all product and variant fields including current stock levels across all warehouses.

Exporting Orders

1. Go to Orders → Export
2. Filter by date range, status, or store
3. Click Export

Order exports include line item details, shipping addresses, fulfillment status, and tracking numbers. Useful for accounting, 3PL handoffs, and reporting.

Importing Customers

Customer records can be imported to pre-populate profiles before connecting a store:

1. Go to Customers → Import
2. Download the customer CSV template
3. Fill in email, first_name, last_name, and optional fields (phone, company, tags)
4. Upload, preview, and import

Customers are matched by email address. A matching email updates the existing record; a new email creates a new customer.