Resolved How to export hikashop to j2commerce

Hello Bear,

got many errors stating the field was not part of ro csvi even though the fields came from the list of fields &/or are listed as part of j2commerce fields.

These are HikaShop supported fields and not supported by J2Commerce and so you see not supported message. You need to map equivalent J2Commerce fields for these unsupported fields. See the list below to map to J2Commerce fields. Once you map to these fields you should not see unsupported message any more.

picture_url -> main_image
picture_url_thumb -> thumb_image
product_keywords -> metakey
product_created -> created_on
visible -> visibility

In the above list metakey is not available in J2Commerce Product import yet. Load the attached patch file and run update of available fields. You should see the field after that.

Let me know on how that goes.

got many errors stating the field was not part of ro csvi even though the fields came from the list of fields &/or are listed as part of j2commerce fields.

Hello,
Your template and import file looks good. We need to check why you are getting the 500 error. Please read through 500 Internal Server Error which explains on possible causes for this error. Also check server error logs and see if you can get any details of the error. Post it here and we can check.

Also post latest import debug log to check. To get the debug log see How to collect debug information? document.

I thought I mapped everything but I get a 500 error. You said to add fields as that wasn't all the fields so I tried to do so. I even edited the .csv to match.

Hi Bear,

I also can't change the column header. Everytime I try it reverts it to match the field name.

The template I sent you is a bridge template where in HikaShop export template on Destination tab I have selected export to J2commerce Import template. This way HikaShop export fields are directly mapped to J2commerce import fields. RO CSVI has few predefined mapped fields for VirtueMart, HikaShop and J2Store saved in one of its database table. So when you save a template field for HikaShop export template RO CSVI saves the mapped field of J2Commerce in Column Header. That is the reason you are not able to change the column header. This will happen only in case of bridge templates.

I thought it got the field names from the 1st row?

Yes the column headers in HikaShop export template fields are used as template fields in J2Store import template which is the first row of HikaShop export.


Can you please tell me the issues you have with the bridge template? I will help you with it.

I thought it got the field names from the 1st row?

Hi Bear,

Thanks for all your help. I wish there was a master import/export fileset

There is no big migration button that does it all. This is something we are thinking about but it doesn't exist now. What you have now is full control over what gets exported and imported.

field mapping: How does j2commerce know which field is which? Are the field names identical?

They are definitely not identical that is why we have to manually map the fields. That can happen in one of two ways:

• Using the correct column headers in the import file
  
• Use the fields assigned to the template and it is order based. So column 1 matches field 1, column 2 matches field 2 etc.
  

pricing: Pricing on most items is 0 which doesn't make sense.

You mean the products show up with a price of 0? If so, are the prices actually being imported?

I noticed you had it set to import from DB which I changed to from local since thats how it needs to be for the user and for the new site.

That is perfectly fine, just need to make sure the import file has the fields in the same order. I guess the idea is that this was being done on a single site.

but there were other settings I was unsure about. ( see images )

As for the image settings, you can click on the Help button in the top right corner and an explanation will appear with every field. Does that help or you still have questions?

Now the fields in the image, what is your question about that? What they do or mean? Usually we recommend that you create 1 product by hand and then export the fields for a product and you can see in which field what data shows up that you put in. That generally gives you a good idea what which field is.

I also can't change the column header. Everytime I try it reverts it to match the field name.

If this is the import template, it is not the fieldname used for the import, that is for your own reference. It is the order of the fields. So for example, if brand appears as fifth column in your import file, you need to drag it to row 5 in the list. Once all fields are done, they should be in the same order as they are in your import file.

Let me know if that helps or if you have any further questions.

I also can't change the column header. Everytime I try it reverts it to match the field name.

I ran your example and am confused about a few things.
field mapping: How does j2commerce know which field is which? Are the field names identical?
pricing: Pricing on most items is 0 which doesn't make sense.
I noticed you had it set to import from DB which I changed to from local since thats how it needs to be for the user and for the new site.
but there were other settings I was unsure about. ( see images )

Thanks for all your help. I wish there was a master import/export fileset

Hello,
You can restore the attached template as it is explained in Backup/restore templates document.

Hello,
I have attached a sample bridge template to migrate HikShop products to J2Commerce products. I have added only a few basic fields. You can add more and map them as it is done in the sample template.

Hope that helps.