Importing Products from text file

[vidmarc]

We're still working on a product spreadsheet, which we have ordered by category. We almost have the fiorst category complete, so is it possible to bulk import products on a category by category (and sub category) basis? 

 

Version: 5.2.5

[Al Brookbanks]

It is indeed. If you create your categories first and make a note of their ID number you can put this on the spreadsheet for import. It will then assign automatically. Alternatively you can bulk assign categories to products after import. 

 

Any generic product CSV file should be accepted by the import tool.

[vidmarc]

I can see a "Master Category ID" option but no option to import sub category IDs.

[vidmarc]

And is there a way to set the Google category ID in the spreadsheet before importing?

[convict]

I can see a "Master Category ID" option but no option to import sub category IDs.

 

Master category can be even a sub category. Master category means the main product category as product can be assigned to multiple categories but not using import tool

 

And is there a way to set the Google category ID in the spreadsheet before importing?

No option at this time but product import tool can be tweaked easily in adminsourcesproducts.import.inc.php

				'brand'				=> $lang['catalogue']['product_brand'],
				'gtin'				=> $lang['catalogue']['product_gtin'],
				'man'				=> $lang['catalogue']['product_mpn'],


to

				'brand'				=> $lang['catalogue']['product_brand'],
				'gtin'				=> $lang['catalogue']['product_gtin'],
				'man'				=> $lang['catalogue']['product_mpn'],
				'google_category'		=> 'Google Category Name',