Product Variants
Last update: 18 minutes ago by Nazar32Reading time: 2 min
Data to be included in file
Note that rows will be sent in this file for ALL Products - this includes those set to Type = “Single”, as well as those set to Type = “Variations”. More explicitly - Products with a Type = “Single” will NOT have any data in the 2 mapping files described on the following pages, but each product that fits this criteria will appear as a single row in the Product Variants DIM file:
- Product Category and Product Category Option Mapping DIMENSION file
- Product Variant and Product Category Option Mapping DIMENSION file
| Field Name in File | Field Description | Sample Data | Field Type | Size | IsNullable | Comments |
|---|---|---|---|---|---|---|
| id | Product Variant UUID | 71bdd68e-f73c-11ea-adc1-0242ac120002 | UUID | No |
| |
| amount | Amount charged for the Product Variant | $40 | Integer | No | ||
| sku | SKU for the Product Variant | S32DF | String | 10 | Yes | |
| available | Available/Unavailable flag for the Product Variant | TRUE or FALSE | Boolean | No | ||
| sortOrder | Sort order indicating which order the Product Variant appears in | 1 | Integer | No | ||
| productId | UUID of the Product that the Product Variant is associated with | 24f9b777-0c8c-4c64-8646-d2473b93d464 | UUID | Yes |