Good morning,
I'm here again asking for help with the usual issue of importing products. I need to allow my client (site owner who does not understand mysql and php because he does another job and not mine) to be able to load products correctly.
Since there are thousands of products I had created a simple form to do it. It works perfectly to load categories etc., but when I have to load the products it doesn't work, or rather, it works but then the database doesn't take the products, I think the reason is the fact that in the table relating to products _phocacart_products the field is not present of categories. And since the categories are mandatory the database does not load the products. How can I do? Or, can you tell me the categories field in the related table? Thanks.
I can't import products
- Jan
- Phoca Hero
- Posts: 48403
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: I can't import products
Hi, the reason is the category feature - multiple category - which means that products can be stored in more categories. To store such data for such feature, new reference table needs to be done. So the category is not stored in product table row, because it can include more than one category, see: https://www.phoca.cz/forum/viewtopic.ph ... 23#p170426
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 49
- Joined: 15 Mar 2020, 16:43
Re: I can't import products
Ok, thank you. I will see the item you suggested me
- Jan
- Phoca Hero
- Posts: 48403
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact: