Learn which fields in Lightspeed are mapped to which fields in Cin7 Core when downloading or listing products.
Product field mapping (import)
Data mapping for products between Cin7 Core and Lightspeed is as follows when downloading from Lightspeed to Core:
| Cin7 Core | Lightspeed |
|---|---|
| SKU | SKU |
| Name | Name |
| Type (Service if "discount" or "gift card", otherwise "stock") | |
| Category | Type |
| Description | Description |
| Barcode | SKU |
| Price Tier. Default is Price Tier 1 | Price (Inclusive or exclusive based on Lightspeed store settings) |
| ECS Custom Field 1 | Handle |
| Brand | Brand name |
| Images | Images |
| Product tags | Categories (Comma-separated list) |
| Weight | Weight |
| Weight unit | Weight unit |
| Dimensions unit | Dimensions unit |
| Width | Width |
| Height | Height |
| Depth | Depth |
| Components | Composite BOM key, quantity |
| Product location | Reorder point, reorder amount, inventory level |
| Option 1 Value | Option 1 Value |
| Option 2 Value | Option 2 Value |
| Option 3 Value | Option 3 Value |
| Option 1 Name | Option 1 Name |
| Option 2 Name | Option 2 Name |
| Option 3 Name | Option 3 Name |
Product field mapping (export)
Data mapping for products between Cin7 Core and Lightspeed is as follows when listing products from Core to Lightspeed. Fields that are not mentioned here (images, dimensions) are not exported to Lightspeed.
| Cin7 Core | Lightspeed |
|---|---|
| Barcode (if available) or SKU | SKU |
| Name | Name |
| Category | Category |
| Description | Description |
| Barcode | SKU |
| Price | Price (Inclusive or exclusive based on Lightspeed store settings and Core tax rule for the product) |
| Stock quantity | Inventory |
| ECS Custom Field 1 | Handle (Handle stored in Custom Field, otherwise alphanumeric representation of SKU) |
| Brand | Brand name |
| Product tags | Tags |
| Option 1 Value | Option 1 Value |
| Option 2 Value | Option 2 Value |
| Option 3 Value | Option 3 Value |