Overview
A CSV file, short for Comma-Separated Values, is a file format used to store data in a tabular form. In Seller Snap's system, users may utilize CSV files to update SKU values.
This is a good way for users to change listings' values in bulk.
Creating a CSV File
To create a CSV file, users will need programs like Microsoft Excel or Google Sheets in order to make sure they are using a .csv file
A typical CSV import file could look like this:
The SKU column is mandatory
It is recommended that users should only include columns for data they want to update and remove any other columns that they will not update.
The following columns may then be used to update a listing's value:
*Required Fields
Field | Accepted column names | Description |
SKU* | sku | Product SKU identifier |
Pricing & Inventory
Field | Accepted column names | Description |
Cost number | cost | Product cost/COGS |
Shipping Cost number | shipping_cost, shipping cost | Shipping cost for FBM items |
Additional Cost number | additional_cost, additional cost | Additional cost per unit |
Fulfillment Cost number | fulfillment_cost, fulfillment cost | Fulfillment cost (maps to shipping_cost) |
Min Price number | min_price, min price | Minimum selling price |
Max Price number | max_price, max price | Maximum selling price |
MAP number | map | Minimum Advertised Price |
Lead Time number | lead_time, lead time | Lead time in days |
Required Days Cover number | req_days_cover, req days cover, required days cover | Required days of inventory coverage |
Markups & Auto-Adjust
Field | Accepted column names | Description |
Set Min Markup number | set_min_markup, set min markup | Set minimum markup percentage (use 'reset' to clear) |
Set Max Markup number | set_max_markup, set max markup | Set maximum markup percentage (use 'reset' to clear) |
Disable Auto Adjust Min boolean | disable_auto_adjust_min, disable auto adjust min | Disable automatic min price adjustment |
Disable Auto Adjust Max boolean | disable_auto_adjust_max, disable auto adjust max | Disable automatic max price adjustment |
Repricing
Field | Accepted column names | Description |
Repricing boolean | repricing | Enable/disable repricing for this product |
Reprice Config Preset | reprice_config_preset, reprice config preset | Repricing strategy preset name (use 'remove' to reset to default) |
Consider Competitive Price Threshold boolean | consider_cpt, consider cpt | Consider competitive price threshold |
Product Settings
Field | Accepted column names | Description |
Small and Light boolean | small_and_light, small and light | Small and Light program enrollment |
VAT Percent number | vat_percent, vat percent | VAT percentage |
Note | note, notes | Additional notes (max 255 characters) |
To Delete boolean | to_delete, to delete | Mark listing for deletion |
Tags
Field | Accepted column names | Description |
Tags | tags | Semicolon-separated list of tags (replaces all existing tags) |
Add Tag | add_tag, add tag | Semicolon-separated list of tags to add |
Remove Tag | remove_tag, remove tag | Semicolon-separated list of tags to remove |
Business Pricing
Field | Accepted column names | Description |
Business Pricing boolean | business_pricing, business pricing | Enable business pricing |
BP Strategy | bp_strategy, bp strategy | Business pricing strategy (e.g., 'ai', 'fixed', 'qd') |
QD Strategy | qd_strategy, qd strategy | Quantity discount strategy |
BP Consider MAP boolean | bp_consider_map, bp consider map | Consider MAP in business pricing |
BP Fixed Config | bp_fixed_config, bp fixed config | Fixed business pricing configuration |
How to Upload a CSV File
The Import function is found on Seller Snap's Listings Page. Simply click on Actions and Import.
Users will receive a notification in their email once the upload is complete.
How to export a CSV file
Users can choose between exporting all columns or just the columns they are currently viewing.