Import Of products with multiple Categories/Sub Categories.csv

[Hooked19]

Hi

I have been reading around all different forums in regards to the import of products using .csv files. What I really need to know is, is it possible to import multiple products at a time, with all needed details for the store but have these products viewable in multiple categories. The first list below is the products i want to add (a few out of 1000's) and below this is the category tree we have created. if possible could someone write an example of the format for the import file. 

 

I am using version 1.6 1.6

 

Products to add - (pricing is only for reference and not actual)

 

 

See attached (sorry unable to attach file) or below as list

 

 

Product Code/Supplier #

WEXBUTTERS

WEXCHORUM

WEXCOCRUM

WEXCHERRY 

WEXCRECHO  

 

Product Description/Names

Samuel Willards Pre-Mix Butterscotch Schnapps

Samuel Willards Pre-Mix Chocolate Rum

Samuel Willards Pre-Mix Coconut Rum

Samuel Willards Pre-Mix Cherry Ripe

Samuel Willards Pre-Mix Chocolate Cream

 

Trade price ex tax

$0.02 

$0.02 

$0.02 

$0.02 

$0.02 

 

 

 

RRP inc tax  

$0.03

$0.03

$0.03

$0.03

$0.03

 

 

               

 

 

Category Tree (Actual)

 

  Home

•   Spirits
  •   Essences
  •   Brands
    •   Still Spirits
    •   Samuel Willards
      •   Express Pre-Mix Range
    •   QHBS
    •   Edwards
    •   Coral Sea
    •   Gold Medal
    •   Prestige
  •   Yeasts
  •   Filtering & Clearing
  •   Liqueur Bases

​​Thank you for your help with this.

Jay

Edited July 14, 2016 by Hooked19 (see edit history)

[Iryna]

Hello 

 

You may consider import functionality of Store Manager for PrestaShop. Any of products you import via product import wizard can be assigned to multiple categories or subcategories. Since you have category tree created, you can specify category IDs in the import file and separate them by double category delimiter within one file cell. Though you can use entire path to your categories in the import file, for example Home|Spirits|Brands if you need to add product to 'Brands' (obligatory if you want to create categories during import to PrestaShop).

 

Here is the tutorial on this topic - https://www.prestashopmanager.com/useful-articles/prestashop-product-management/import-prestashop-products-into-multiple-categoriessubcategories/.  

 

Sample file (with category paths) is available in this article - https://www.prestashopmanager.com/useful-articles/how-to/how-to-assign-multiple-products-to-categories/. If all the categories, you import products to, already exist at your store, you can use their IDs instead of paths.

[Hooked19]

Hey 

I am actually trying to work out how to write this. I do not want to purchase an office module if it is not needed?

 

thx 

[Teapot Creative]

Hi Hooked19

 

I have produced a video "how to"  tutorial that covers CSV importing of products and categories as well as other importing options for Prestashop. This may help you in understanding importing data into Prestashop. 

 

 

 

Hope this helps.. 

NickC