How do I import my cost information into SmartPrice?

Download the CSV template, add your data inputs, and import your CSV file into SmartPrice.

Overview:


If you have a product catalog larger than twenty items or so, editing cost and margin information line by line in editing mode could get tedious.  That’s why SmartPrice offers CSV Upload as the preferred way to add your costs and desired margins to the tool. This way, you can easily leverage SmartPrice’s powerful dynamic price threshold adjustment, to ensure every sale you make meets your standards of profitability.

(NOTE: CSV Upload only works to update existing Amazon Listings. You cannot use CSV Upload to add new listings to Amazon. Attempting to do so will result in those listings and their data being reported as errors, and their data will not be added to SmartPrice.)

Download the template

We recommend that, before uploading cost information, you download our CSV template from the listings grid.  By default, downloading the CSV template will produce a CSV containing your entire product catalog.  If that is undesired, use the search and filter pane to produce the list of SKUs that you want to work with, and download the CSV at that point.

The following columns are included in the template. Note that some are required, while some are optional, and that some of these columns are read-only, and cannot be used to change data in SmartPrice.

  • Required/Read-only: The following fields must have valid data for SmartPrice to correctly identify which listing will be updated:
    • SKU (RO*)” -  Your internal product identifier for your listing. Needed to make sure we’re updating the correct listing. Expects a text string.
    • ASIN (RO*)” - Amazon Stock Identification Number, assigned by Amazon to your listing. Needed to make sure we’re updating the correct listing. Expects a ten (10) character alphanumeric string.
  • Optional/Read-only: The following fields are there to provide you with additional information about the included listings for reporting purposes. Nothing you do to these values in your spreadsheet/csv file will have any impact on your SmartPrice data.
    • Item Description (RO)” - Usually what your listing is called on Amazon
    • Amazon Listing Status (RO)” - This indicates whether or not your listing is currently available for purchase to a customer on the Amazon Marketplace. Expected values: Active, Inactive, Incomplete
    • Fulfillment Channel (RO)” - This indicates who is fulfilling an order for this listing. Expected values: FBA, FBM
    • My Current Price (RO)”: The price at which a customer could currently purchase your listed product from you. Expected value: price in dollars and cents (E.g., X.XX or $X.XX)
    • Buy Box Price (as of Last Assessment) (RO)”: The price at which a customer could currently purchase your listed product from the Buy Box by clicking “Add to Cart.” Expected value: price in dollars and cents (E.g., X.XX or $X.XX)
    • Buy Box Winner (as of Last Assessment) (RO)”: This indicates whether or not your listed offer is the current winning buy box offer: Expected value: Yes/No/Blank
    • Last Assessment (RO)”: The time and date at which SmartPrice last detected seller activity on your listing. Expected value: MM/DD/YYYY HH:MM:SS
    • Calculated Min Price (RO)”: The minimum price that SmartPrice has determined will get you your desired margin, after all costs and Amazon fees have been covered, (based on the cost data and desired margin you supply). Expected value: price in dollars and cents (E.g., X.XX or $X.XX)
  • Optional/Editable: The following columns are the ones that you can use to update data in SmartPrice. Note the expected values that each field takes. Leaving a field blank will tell SmartPrice to make no change to that field. To clear a field in SmartPrice, enter <none> in the field.
    • Repricing Enabled?”: This indicates if you want SmartPrice to manage the repricing of your listing (NOTE: To enable repricing, the listing must have a minimum price. Learn more about setting a minimum price here). Expected inputs: Yes/No/Blank
    • User-Defined Min Price”: The lowest amount at which you would allow this product to be sold. Overrides the Calculated Min Price. Must be lower than your maximum price. Expected value: price in dollars and cents (E.g., X.XX or $X.XX)/<none>/Blank
    • User Defined Max Price”: The highest amount at which you would allow this product to be sold. Overrides the Calculated Max Price. Must be higher than your minimum price. Expected value: price in dollars and cents (E.g., X.XX or $X.XX)/<none>/Blank
    • Supplier Cost”: The amount that you pay per item to source this product. Expected value: price in dollars, up to four (4) decimal places (E.g., X.XXXX or $X.XXXX)/<none>/Blank
    • Desired Margin Absolute”: The amount of profit you want from a sale, after all costs and fees have been removed. Expected value: price in dollars and cents (E.g., X.XX or $X.XX)/<none>/Blank
    • UDC: [COSTNAME]”: Each user-defined cost that you have added to SmartPrice will have its own column here so you can include them in the minimum price calculation that SmartPrice performs. Expected value: price in dollars, up to four (4) decimal places (E.g., X.XXXX or $X.XXXX)/<none>/Blank

Upload the file


Once you have edited the CSV to include all the data you wish to enter into SmartPrice, save the file as a .CSV file type. Click the CSV upload button in the top right corner of the listings grid
  1. Choose File: This will bring up a file explorer window allowing you to select the CSV file to upload.
  2. Start Upload: This will begin the upload process, and SmartPrice will parse the data to be sure that the data is properly formed, and that the price thresholds are logical (Min Price < Max Price)
  3. (Optional, but recommended) Review parsing results: If there are any errors or warnings, you will be given the option to download a CSV containing the parsing results (errors only, errors & warnings, or all listings), which will identify any issues encountered during parsing so that you can correct them and re-upload the affected rows.
  4. Update listings: You are given the option of applying all changes that received no warnings, or applying the changes for rows with warnings and without warnings.  (NOTE: You cannot apply changes for rows with parsing errors. Correct any errors, and reupload them to apply changes for those rows)
  5. (Optional, but recommended) Review update results: If SmartPrice has difficulty saving your changes to the tool, those errors can be downloaded as a CSV, so you can attempt to reupload them successfully. If this happens repeatedly, please contact Customer Success for help.

Your listings are updated!


Congratulations, your data is now in SmartPrice!