This sample product showcases the ability to split pricing data into multiple CSV documents for a single product.
Our example CSV's only contain a few entries per CSV, however this functionality is intended for use when the possible configurations number in the thousands.
When the configuration of product attributes (such as A & B) are changed, the Infigo system has to look up the updated pricing information from the provided CSV. For very large CSV's (over 1000 entries as a general rule of thumb), this can take a noticable amount of time.
By splitting one large CSV into multiple smaller CSV's, we can ensure the loading time is decreased.
This functionality relies on several entries in the pricing script configuration:
- subDirectory | A folder created within Infigo's Global Additional Data area, in which your partial CSV's will be placed.
- baseFileName | A common prefix on all of the partial CSV's uploaded to your subdirectory.
- separator | A common delimiter located in the name of all of your partial CSV files.
- splitMapping | Identification of the attribute(s) by which the CSV's are split. In our example, the splitMapping is set to "B" and there is a different partial CSV for each possible value of the "B" attribute.
{
"filePath": "",
"quantityColumnName": "Quantity",
"baseFileName": "Subdirectory",
"subDirectory": "Subdirectory",
"separator": "-",
"splitMapping": ["B"]
}