CSV File Guidelines
fabric doesn’t support any other data or file formats. Here are the key points to consider:- The headers, represented in the first row of the CSV file, should match the product details.
- Empty rows and columns are ignored. Ensure that fields don’t contain blank spaces, returns, line breaks, or other characters not supported in the CSV.
- fabric provides a CSV template file. Not following the parameters in the template can result in errors when uploading.
Product Price Data Formatting
When preparing a CSV file for import, ensure that the product pricing data format aligns with the following column requirements:| Header | Description |
|---|---|
| SKU ID | The SKU ID of the item in Product Catalog. |
| Cost Optional | The cost of the item set by the distributor. |
| Price | The price set in fabric to charge buyers for their purchases. |
| Clearance Price Optional | The lowest price set in fabric to charge customers for their purchases. |
| Start Date | The date the price change begins. Dates must follow the YYYY-MM-DDTHH:MM:00.000Z format. For example, a price change scheduled for June 1, 2025 at noon would be 2025-06-01T12:00:00.000Z. |
| Price List Name | The name assigned to a price list when created. |
| SKU ID | Cost | Price | Clearance Price | Start Date (UTC) | Price List Name |
|---|---|---|---|---|---|
| SOME_SKU_ID | 111 | 2025-12-15T02:05:46.000Z | Default_PriceList_Name |
Prerequisites
- Ensure that you have the Offers Editor, or Administrator privileges to fabric Offers. For more detailed information on these settings, see the Role-Based Access Control section.
Procedure
- In the left menu, click Offers.
The Products Pricing page is displayed. - Click Add Bulk Price.
The Import price CSV file window is displayed. - Download the sample template by clicking Template: Price.
- In the Import price CSV file window, do one of the following:
- Drag and drop your file to the window.
- Click Select a File from your computer and select your file.
- Click Import File.