The Advanced CSV connector is in Early Access. If you're interested, you can click here to apply to our Early Adopter Program.
Note: The Advanced CSV connector is only available to Premium subscribers. Contact Inventory Planner Support to learn more about upgrading to Premium.
If you have bundles or assemblies, you can manage their configuration using a variant component file.
The bundle or assembly parent is set up in the variant file, by setting the TYPE field to “bundle” or “assembly”. The components should also be set up in the variant file, with a TYPE of “simple”.
Then the components that make up each bundle or assembly are supplied in the variant component file, with the VARIANT_ID field set to the parent bundle or assembly’s ID.
Note: The variant file must be supplied to the Advanced CSV connector before or at the same time as the variant component file.
Variant component data columns
The variant component file supports the following columns. If a required column is missing, or an unsupported column is present in the file, the file will not be processed.
Column name | Required | Column type | Comments |
VARIANT_ID | ✓ | VARCHAR(256) | The VARIANT_ID of the bundle or assembly parent associated with the component. |
COMPONENT_VARIANT_ID | ✓ | VARCHAR(256) |
|
QUANTITY | ✓ | FLOAT | How many units of this component are used in the bundle or assembly. |
REMOVED | ✓ | BOOLEAN | Soft remove the component by setting to “true” |
UPDATED_AT | ✓ | TIMESTAMP_NTZ | Row last updated timestamp |
PRICE |
| FLOAT |
|