How to Price Your Products

Learn how to price the products on your Spinstak eCommerce website at the product level or save time with our Price Data Export and Price Data Import tools.

How to Price Your Products Featured Image

Keeping your product pricing up-to-date is crucial for your Spinstak eCommerce website and we've created some tools to make it easy. Follow the simple steps below to learn how.

Hate to read? Watch our step-by-step video on How to Price Your Products.

How to Price Your Products-1

 

Price at Product Level

Price Using Export/Import Tool

How to Price Your Products at the Product Level

(Recommended for Editing Only a Few Product Prices)

1. First login to your Admin Panel.

2. On the left-side menu, click Catalog Management. This will open a dropdown menu.

3. From the dropdown menu, click Organize a Catalog.

 

 

4.  From the catalog dropdown menu, select the catalog where you'd like to edit pricing.

5. Locate the category or subcategory where the product resides and click the Products button.

6. Locate the product you'd like to add or edit the price on. Under the View column, click on the SKUs button.

7. From this page, you can either:

    • Click on the Manage Pricing button.
    • Under the Pricing column, click the View button.

8. Locate the Price field and add or edit the price you'd like to show for that product on your website.

 

How to Price Your Products Gif

 

9. To add a Quantity Break:

    • Enter the product quantity into the New Quantity Break field.
    • Click the ADD button.

 

 

10. To add a Sale Price or Percent Off Discount:

    • Click on the SHOW SALES OPTIONS button.
    • If you'd like to add a Sale Price, enter that into the Sale Price field.
    • If you'd like to add a Percent Off, enter the percentage into the Percent Off field.

 

 

11. Click the UPDATE button.

How to Price Your Products Using Our Price Data Export / Import Tool

(Recommended for Editing Several Product Prices)

1. First login to your Admin Panel.

2. On the left-side menu, click Pricing. This will open a dropdown menu.

3. From the dropdown menu, click Price Data Export. This will take you to the Price Data Export page.

 

 

4. Under the Catalog section, click the Select a Catalog to Export dropdown menu and click on the catalog you'd like to export pricing from.

5. Under the Category section, you have a few options:

    • To add or edit pricing within a top level category:
      • Click on the Top Level Category dropdown menu.
      • Select a top level category.

 

  •  
    • To add or edit pricing within a subcategory:
      • Click on the Top Level Category dropdown menu.
      • Select a top level category. This will populate subcategories in the Category field below.
      • From the Category field, select a subcategory.
      • Click the Right Arrow icon ➡️. This will move the selected subcategory over into the Selected Categories section.
      • Tip: You can repeat this process to add multiple subcategories to your Price Data Export.
      • To remove a subcategory from the Selected Categories section, select the subcategory within the Selected Categories section and click the Left Arrow icon ⬅️.

 


    • To add or edit pricing from a specific manufacturer:
      • Click on the Manufacturer dropdown menu.
      • Select the manufacturer.
    • To add or edit pricing within the entire catalog:
      • Click on the Check to Export All Categories In This Catalog checkbox.

 

 

6. Click the Export File button.

 

Important: Do not navigate away from the page while the export file is being prepared. Larger files will take several minutes to export.

 

7. Once the file is ready, click on the Click Here To Download link near the top of the page.

 

 

8. Locate and open the Price Data Export Excel Spreadsheet that you've just downloaded. It likely resides in the Downloads folder on your computer.

 

Important: DO NOT ADD OR DELETE ANY COLUMNS. If you do, you will be unable to import the spreadsheet back into your store.

 

9. To add or edit the List Price, locate and change the price in Column J (PRICE 1).

 

Note: Any product with 0 in Column J (Price 1) will show by default on your website as "Call for Pricing".

 

10. To add or edit the Sale Price, locate and change the price in Column K (SALE PRICE 1).

11. To add or edit a Discount %, locate and change the number in Column L (DISCOUNT % 1) to the percent off discount you'd like to display.

 

 

12. To add Quantity Break Pricing:

    • Add the next product quantity in Column M (QTY 2).
      • For example, if you want to have a special price for customers who order 20 or more of a particular product, you would enter the number 20 into Column M (QTY 2). On your website, a price would be displayed for a quantity of 1-19 and a price would be displayed for a quantity of 20+.
    • Add the List Price in Column N (PRICE 2) for the quantity entered in Column M (QTY 2).
      • For example, if you want to have a special price for customers who order 20 or more of a particular product, you would enter the price per product into Column N (PRICE 2).
    • If you'd like to add a Sale Price to the quantity break, you can enter the sale price in Column O (SALE PRICE 2).
    • If you'd like to add a Discount % to the quantity break, you can enter the discount % in Column P (DISCOUNT % 2).
    • You can follow these same steps to add up to 9 different quantities.

 

13. To add a Custom Part Number, enter your custom part number in Column AU (Custom Part Number).

14. To override the current Unit of Measure, enter the unit of measure you'd like to use in Column AV (UOM Override).

 

Important: Only edit the fields from Column J to Column AR and Column AU to Column AV.

 

15. Once you've finished editing the Price Export file Excel spreadsheet, save the file as an Excel 97-2003 Workbook (*.xls).

 

 

16. Close the Price Export file Excel spreadsheet.

17. Return to the Admin Panel.

18. On the left side menu, click Pricing. This will open a dropdown menu.

19. From the dropdown menu, click on Price Data Import.

 

 

20. This will take you to the Import Pricing Data page. On the righthand side of the page, click Choose File.

21. Locate your saved Price Export file Excel Spreadsheet (saved as an Excel 97-2003 Workbook) and click Open.

22. Click the Upload Pricing Data button.

 

 

Note: If your file is not compatible, you will receive an error message with suggestions on how to resolve the issue with your file.