How to Import Additional Product Views

You cannot currently import additional product views using the Import Wizard. The reason this cannot be done during an initial product import is because the Product ID in the database needs to be known before the additional image views can be assigned (and when products are being added, there is not yet a Product ID in the database).

This feature might be added to the Update Product mode within the Import Wizard (to update existing products) in the future.

In the meantime, you can try importing that information directly into the “pcProductImages” table using the import features that are built into MS Access and MS SQL. For example, assuming that you are using MS SQL (always recommended):

• Your Web hosting company might offer a Web based interface to gain access to the MS SQL import tools (e.g. “Manage Database”)
• If not, you can use MS SQL Enterprise Manager (SQL 2000) or SQL Server Management Studio (the Express version is free). See information about using these tools.

The fields to import into the “pcProductImages” table are:

• ID of the product that the images refer to (idProduct field in the table)
• File name of general image (pcProdImage_Url field)
• File name of detail view image (pcProdImage_LargeUrl field)
• Order in which to display the image relative to the other “additional views” for that product (pcProdImage_Order field)

In v4.5, we have added a very 'basic' import feature that allows store owners to separately:

• Import Additional Product Images that have not yet been assigned
• Replace Existing Additional Product Images (unfortunately, it is not possible to add to existing Additional Product Images)

You will find this option under the “Products” menu in the ProductCart Control Panel. There is a limitation of 6 Additional Views (12 images) for this import.

The Import File must be in XLS format using the same principal as described in the main Product Import instructions… and must use the following header variables (column names) EXACTLY:

a. SKU

b. Image1_General

c. Image1_Detail

d. Image2_General

e. Image2_Detail

f. Image3_General

g. Image3_Detail

h. Image4_General

i. Image4_Detail

j. Image5_General

k. Image5_Detail

l. Image6_General

m. Image6_Detail

You can download a template here

Note: the images themselves must be uploaded to the “pc/category” folder on the server.

• About Additional Product Views
• How to Setup Additional Product Views of the Same Height
  This solves an interface issue.