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 to create or edit spreadsheets.
A CSV will contain columns and rows. Columns will represent the name of the value to be changed and the rows will contain the value itself.
A typical CSV import file could look like this:
The SKU column is mandatory as this tells the system where the values will be placed.
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:
Columns | Description |
tags | Set tags for a Listing, use semi-colons to add multiple tags. |
note | Places a note for a Listing. Updates the "Note" column. |
additional_cost | Adds an additional Cost to a listing. Updated the field for the "Additional Cost" column. |
fulfillment_cost | For FBM listings only. Updates the "Shipping Cost" column. |
min_price | Sets a min price. |
max_price | Sets a max price. |
repricing | Enable or Disable repricing; ON or OFF values only. |
reprice_config_preset | If a user has created a repricer preset, they may place the exact name of that preset here |
set_min_margin OR set_min_markup | Depending on whether the user has set either markup or margin for their Min & Max Calculation Method. |
set_max_margin OR set_max_markup | Dependent on whether the user has set either markup or margin on their Min & Max Calculation Method. |
disable_auto_adjust_min | See dedicated article: Tier Markup Based On Cost. |
disable_auto_adjust_max | See dedicated article: Tier Markup Based On Cost. |
vat_percent | EU Stores ONLY |
map | Sets MAP price for a listing |
store_id | For Accounts that have multiple stores. Used to designate which store the SKU is in for the changes. For assistance with Store IDs, please contact Customer Support. |
Premium Only
Users with Premium Subscription are able to set and use the following optional columns
Columns | Description |
lead_time | Lead Time; If using the Inventory Planning Tool. See dedicated article: Replenishment Quantity Suggestions |
req_days_cover | Required Days of Coverage; If using the Inventory Planning Tool. See dedicated article: Replenishment Quantity Suggestions |
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.