Navigation:  Categories & Products >

Bulk Uploading of Products

Previous pageReturn to chapter overviewNext page

 

This section allows you to upload product data into your Pinnacle Cart using a .CSV file. Most database programs (including Excel) will allow you to import or save data in this format. Once uploaded, Pinnacle Cart will ask you which column represents what data type (Product ID, Product Name, Price, etc.). Pinnacle Cart uses Product ID as its data key, so products with a duplicate Product ID will be overwritten with the new data. This is a 3-step process and the data will not be stored until the final step is complete.

 

1.      Click Bulk Products Loader, as shown in the Figure 2-21-1 below.

 

clip0017

Figure 2-21-1: Bulk Products Loader

 

The Bulk Uploading Of Products (Step 1 of 3) page will open.

 

Note: You can also directly open the Bulk Uploading Of Products (Step 1 of 3) page, by clicking on Bulk Products Loader link in the Admin Area Home page.

 

2.      Category: Select a Category that allows selecting products category with undefined category keys. The products with undefined category will be moved to this category.

 

image119

Figure 2-21-2: Default Products Category

 

3.      Uploading Settings: Enter the following information:

a.      Data Separator: Select from the drop down menu, comma or semicolon, which is used as a data separator.

b.      Data Update Rule: Select from the drop down menu, if the bulk loader has a duplicate Product ID, should it overwrite the existing data with the bulk loaded data, keep it and add new, clear all the products from the selected category first and then add a new bulk loaded data or update existing products only.

c.      Uploaded Products Availability: Use this option to enable/disable display of these products on Pinnacle Cart. Select from the drop down menu, Products Are Available For Sale, if you want to display these products on Pinnacle Cart. Otherwise, select Products Are Not Available For Sale, if you do not want to display these products on Pinnacle Cart. Incase you would like to display some of the products this has to be done manually.

 

image121

Figure 2-21-3: Uploading Settings

 

4.      Click Browse to select the .CSV file with products data.

 

image123

Figure 2-21-4: File With Products

 

5.      If you want to reset the form, click on the Reset form button.

6.      Click Upload file button to save the data.

 

The Bulk Uploading Of Products (Step 2 of 3) page will open, as shown in the Figure 2-21-5.

 

Note: All blank lines and lines with wrong price will be skipped.

 

image125

Figure 2-21-5: Bulk Uploading Of Products (Step 2 of 3)

 

7.      Select the respective titles for the data in the lines from the drop down menu.

8.      Click Back button to go back to Bulk Uploading Of Products (Step 1 of 3) page.

9.      Click Insert into DB button to go to the next-step.

 

The Bulk Uploading Of Products (Step 3 of 3) page will open, as shown in Figure 2-21-6. This page will show the complete details regarding the Bulk uploaded products.

 

image127

Figure 2-21-6: Bulk Uploading Of Products (Step 3 of 3)