Knowledgebase: Products
How do I import Bulk Pricing via CSV?

Absolutely! 3dcart allows you to easily setup your online store by importing and exporting the bulk of your current store information. Such information includes customers, products, product options, and images. This guide will give you a step-by-step process on how to import your product bulk discount pricing information.

Import Bulk Discount Pricing

While logged into your 3dcart Online Store Manager, use the left hand navigation menu and:

  1. Go to Products ->Product List
  2. Look towards the top right of the page and click on the "Export/Import" button

The Export/Import page will contain Export options on the left hand side and Import options on the right hand side.

  1. Look towards the right hand side of the page and click on the +Icon next to "Bulk Pricing "
  2. Next, click on the "Sample File" link to download a clean copy of the import CSV

This file will give you a template of what information to include in your spreadsheet so you may import your information to your online store.

Here is a sample from a portion of what your spreadsheet will look like:

You may now add Pricing information to the proper columns.

Note:
Do not remove, add, or edit any columns to this file.. If you do not have a need for a column please leave it blank. This is the exact format the file needs to be to import your Pricing information properly.

Here is a description of each field:

  • Catalogid
    This is a unique database ID that will be used to keep track of each product in the backend of the system. This is not the same as the productid.
  • Productid
    It is the unique product id (SKU or Part Number) of the product.
  • Lowbound
    This is the low end of your range (number of products) for customers to receive bulk discounts.
  • Upbound
    This is the high end of your range (number of products) for customers to receive bulk discounts.
  • Price
    This is the discount amount the customer will receive if they are applicable for the bulk discount.
  • Percentage
    Shows if the discount is a percentage – 1 for yes, 0 for no.
  • Price_level
    Shows which customer group/price level receives the bulk discount. If none are specified, the default will be 1.

For items with multiple ranges, populate the next row without the catalogid and product id.  Then, add the lowbound and upbound and populate the rest of the columns accordingly to get all of your ranges added for the one product.

In the above example the first product has three ranges:

  • Range 1
    5 to 10 items receive a 1 dollar discount per item
  • Range 2
    11 to 20 items receive 2 dollars off per item
  • Range 3
    21 items or more get a 5% discount per item

The second product has only one range.

  1. Once you have filled in your information, save the file to your computer
  2. Once again, go to Products ->Product List and look towards the top right of the page and click on the "Export/Import" button
  3. Look towards the right hand side of the page and click on the +Icon next to "Bulk Pricing "
  4. Browse for your file in the Import section.
  5. Click Import Data

Your bulk prices will be imported to the store.



Attachments 
 

Help Desk Software by Kayako fusion