export and import of categories and products

  • Posts: 14
  • Thank you received: 0
  • Hikashop Business
2 weeks 3 days ago #333073

-- HikaShop version -- : 4.4.2
-- Joomla version -- : 3.9.26
-- PHP version -- : 7.4.9
-- Error-message(debug-mod must be tuned on) -- : need information on export and import of products

need information about import and export of

category name
category description
meta description
page title
alias
Canonical URL
category image
published yes
parent category
layout product page - tabular
quantity input method - inherit
access level all


Product without variants ( for some categories)
products with variants ( for some categories)


i have checked forum for any information. but i wont find any CSV format. please provide csv format to import categories . products and products with variants

1. product code has to manually enter or system will autp generate?
2 Category code has to manually enter or system will autp generate?
3. Where to place images . ?
4. i am using hikashop business then how to use product template?
Please

regards

Please Log in or Create an account to join the conversation.

  • Posts: 73081
  • Thank you received: 11164
  • MODERATOR
2 weeks 3 days ago #333075

Hi,

1. While the product_code is not mandatory, if you don't specify it, the system will use the product_name as product_code. If the product_name is not specified either, then it will be refused. Also, note that if you import variants, you need to specify the product_code of the parent product in the order_parent_id column of the variants. So in that case, the product_code column will be necessary in your CSV.
2. The category_namekey will be generated automatically and is not visible on the interface anywhere so you don't have to take it into account.
3. Images can be placed in the "upload folder" that you configured in your HikaShop configuration. By default, it is images/com_hikashop/upload/
4. You need to create a product configured like you want. Then, when you are on the import screen, select that product in the template setting. During the import, all the columns not provided in your CSV but filled in in the settings of that product will be copied over to the imported products.

You can read more about all of these, with several of these points explained on this documentation page about the import system:
www.hikashop.com/support/documentation/73-hikashop-import.html
I would also recommend that you first create 2 or 3 products like you want and export them with the "export" button of the products listing.
That will give you a CSV file that you can base yourself on to know all the columns you can use (which could vary, based on what extra plugins you have installed, custom fields you've configured, etc) and what to put in each one.
Finally, note that you can also use RO CSVI: rolandd.com/
It's an extension dedicated to import and export so it has more advanced functions.

Please Log in or Create an account to join the conversation.

  • Posts: 14
  • Thank you received: 0
  • Hikashop Business
1 week 2 days ago #333363

when i export from products i got this file.

very confusing with lot of colums

can u please tell me simple add model for

categories
products
and product variants

plz

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 73081
  • Thank you received: 11164
  • MODERATOR
1 week 2 days ago #333366

Hi,

The import documentation link I gave you has a whole section which explains all the main columns that you need to use to import products with category and products with variants, and it has examples of CSV files :
www.hikashop.com/support/documentation/7...shop-import.html#csv
Also, if you don't want all the columns and don't want the first rows where the category tree is defined, you can use the action "export a CSV file" after selecting the products on your products listing and clicking on the "actions" button.
It will let you choose the columns that you want in the resulting CSV file.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum