unicsvimport - limit of import?

Aw: unicsvimport - limit of import?

Import from JS 4.x to 5.x it´s hair-pulling!

many attempts with import tables. But only errors:

addon_prod_availability_custom_status' in 'field list

Frontend is Dead. In Backend looks good. Alle Products / Categories / Connection seem to be there

But where does the message "addon_prod_availability_custom_status' in 'field list" come from after Import all _jshopping_ Database Tables?

---

Aw: unicsvimport - limit of import?

I found out that you shouldn't import the tables
jshopping_addons

, otherwise all the addons from the old shop will be taken over, some of which are not compatible.

this error still occurs in the frontend after each import:
"addon_prod_availability_custom_status' in 'field list"

Presumably from a table that shouldn't be imported either. But which?

Aw: unicsvimport - limit of import?

I suspect that problem of these errormessage lies in the
_jshopping_categories

database

after emptying, at least the front end works again without an error message. Categories are gone after emptying of course ....

Solution?

Aw: unicsvimport - limit of import?

!

Aw: unicsvimport - limit of import?

OK. further insight. If don't import the category from the old shop, there will be no error message in the frontend. But as soon as you assign a product to a category, this error appears again and the frontend is dead.

Aw: unicsvimport - limit of import?

1. create copy your old shop
2. update Joomla
3. update shop

All data Shop (DB shop) -> in new joomshopping version.

new joomshopping version: clear Joomla / JoomShoping without addons.

------------------------------------------------------------------------------------------------
or

disable / delete installed plugin from new joomshopping version

---

Aw: unicsvimport - limit of import?

Disable plugins in new shop after import??? Or? After disable? Enable? Don’t understand

Aw: unicsvimport - limit of import?

ok.
-----------
for fix message "addon_prod_availability_custom_status' in 'field list"

delete Availability info

Aw: unicsvimport - limit of import?

In new shop I don’t have this addon!

In old shop tried to delete addon after update and before exporting database. But no success. Still error

---

Aw: unicsvimport - limit of import?

Or you mean delete Addon before update Joomla and Joomshopping in OLD store? I don’t understand

Aw: unicsvimport - limit of import?

You have confused me too.

Error in new store.
Delete addon from new store.


new store clear Joomshopping?

Aw: unicsvimport - limit of import?

Ok. You´re right. Addon was installed at new store. After delete and re-install, seems the database-import worked. I make some tests and give you feedback later. Thanks.

Aw: unicsvimport - limit of import?

addon_prod_availability_custom_status' in 'field list is fixed after delete avability info addon.

But now next error after choose a category in Frontend:

Column 'extra_field_1' in field list is ambiguous

How can I fix this??

Aw: unicsvimport - limit of import?

Your copy all table _jshoping_... ?

Need copy table __jshopping_products_extra_fields

Aw: unicsvimport - limit of import?

Yes. All tables import, also extra fields ....

Aw: unicsvimport - limit of import?

And i checked in Backend - all charasterics in new shop are same as in old shop.

---

Aw: unicsvimport - limit of import?

Update from J4.x - J5.0.0 - not finished or ..

Update - should automatically transfer the fields to the new table (_jshopping_products_to_extra_fields).
_jshopping_products -> _jshopping_products_to_extra_fields


delete fileds
extra_fied_1, extra_fied_2 ... from table _jshopping_products

---

Aw: unicsvimport - limit of import?

Ok, delete following tables in jshopping_products:

-extra_fied_1
-extra_fied_2
-extra_fied_3
-extra_fied_4
-extra_fied_5

Error is fixed! That was not easy!!!! I hope that was it with errors after update!
Thank you for support.