Resolved How to create export csv for all j2commerce items.

Hey Roland
The weight, width, length, height measurements arrived - the field about cm or kg did not.
Not sure on the CSV or why it wouldn't have been there.
I'm just racing trying to deal with what I got to work with.
Thanks again,
Alison

Hi Alison,

Surprised that the measurements did not come through as I do see them in both the preview and the products I imported. Assuming it is the ones on the Shipping tab we re talking about.

As for the additional images I see that they are not imported but I don't see any in the simple CSV file either.

Anyway, if there is anything we can do to help, let us know.

Hi Roland
Thanks so much for checking in. Truly appreciated.
Got the items over but in instances where there was more than one image (many items had 4 outside of thumb/intro which uses the first image) only one came over. On measurements and weights the type of measurement was dropped ie cm and kg.
I'm of course going through them product by product as I would need to.
Alison

Hi,

Just wanted to ask how things are going. Are you making any progress?

Hi,

So I had a look at the not so simple CSV file The first thing that I notice is that it contains quite a few fields that end with _id. We discourage the use of those fields because these are database controlled fields. Now we don't go as far as forbidding it but you need to make sure you have the correct IDs instead of letting RO CSVI look up the IDs. For example, the CSV file has a manufacturer_id of 6, if that manufacturer ID does not exist in the manufacturers table, it will point to nothing. Instead the field manufacturer_name should be used. The same goes for the taxprofile_id where we recommend using the taxprofile_name field.

What this CSV is, is actually a combined Joomla content and J2Commerce Product import. You will see that if you run the Joomla content import, the majority of these fields are supported while you then get a list of J2Commerce fields that are unsupported.

The only field that really stood out and did not mean anything to me is the brand_desc_id field. That is a field only used when you create/edit manufacturers as it links to a Joomla content ID. That is a field that does not belong in a product import if you ask me.

One thing you can also wonder, which fields do you really need? Are you migrating a complete webshop or are you just trying to add some products into the existing webshop? The J2Commerce Product import is currently not equipped to be a full Joomla Content import.

The simple CSV seems to be more a migration file than anything else.

To summarize what you can do is this:

1. Create a Joomla Content import template
   
2. Map the fields related to the Joomla Content import and skip the fields unknown to this import
   
3. Create a J2Commerce Product import template
   
4. Map the fields related to the J2Commerce Product import and skip the fields unknown to this import
   
5. Run the J2Commerce Product import
   
6. Run the Joomla Content import
   
7. Check the results
   

Step 1-4 I have done for you and you can find the templates in the attached zip file. Restore these templates and then you can use them. They both start with the word simple in case you need to look for them in your template list. It is important to run the J2Commerce import template first and only then the Joomla Content import.

These templates are based on the simple csv file you provided, so that file must be used with these templates.

Let us know how it goes.

I did a test to see if I could import the simple csv file and it reported these fields as invalid

 	These fields have been found but are not supported by RO CSVI:



    brand_desc_id

    state

    created

    created_by_alias

    modified

    checked_out

    checked_out_time

    publish_up

    publish_down

    images

    urls

    attribs

    ordering

    metadata

    note



Either these fields do not exist in your system, or the list of available fields need to be updated. Update the list to ensure you have all fields available.