News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

Import Wizard with Sub Category

Started by ashtonm, September 20, 2020, 07:40:46 PM

Previous topic - Next topic

ashtonm

I am having a problem with importing products into the right 'Sub Category'

for Example:
I have a Parent Category we'll call it 'Torches' and 'Torches has a 'Sub Category' called 'Night & Day'. These have already got products in.

I'm now trying to import products E.g. 'Super Torch' and that needs to be in 'Sub Category' Night & Day'.

It imports the product but creates a new 'Parent Category' called 'Night & Day'

The only way around this as I can find is buy calling the 'Sub Category' 'Night & Day' as SQL does not like just the '&' on it's own.

Other Imports allow this single '&' but not as described above.

Anyone know a way of fixing this in the code?

This must be a bug so needs looking into.

Thanks, and love using the cart.

Mike

Basara

Hello.

In CSV file for ptoduct set the full path to category like Torches, Night & Day
In the Improt wizard make sure to fill the "Split data by" field with comma
https://abantecart.atlassian.net/wiki/spaces/AD/pages/16777227/Import+Wizard

ashtonm

I did this also.

The bug is in the php for writing a sql update, alter or create statement.

It should read UPDATE table set category.name = 'Night & Day'

It is the same for "/ ' :"  etc...

I have done a search and replace in the csv to change '&' to '&' before import.

You don't need to do this on creation of sub categories. I creates without an issue.

Hope this makes sense and can be put right in future releases.

Cheers

Forum Rules Code of conduct
AbanteCart.com 2010 -