Adding Bulk Price - Fabric
Add Bulk Price
The Add Bulk Price feature allows you to upload a CSV file with details such as cost, price, and clearance price. This streamlined process eliminates the need for manual data entry, reduces errors, and saves time.
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. |
Below is a sample of a valid CSV file for bulk price import:
| 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.
The CSV file is imported, and the prices are added to your products.