I'm trying to export product data and feed to Google Merchant Center. The Description column is incomplete, and is spewing over into other columns such as Price, Image Link, Product Link, brand, mpn, Availability, etc..in other words data is all over the place. There's no uniformity of data across various columns. Please help, this very frustrating. I have tons of products that need exported to Google Shopping.
I'm trying to export product data and feed to Google Merchant Center. The Description column is incomplete, and is spewing over into other columns such as Price, Image Link, Product Link, brand, mpn, Availability, etc..in other words data is all over the place. There's no uniformity of data across various columns. Please help, this very frustrating. I have tons of products that need exported to Google Shopping.
Thanks
In
app/controllers/backend/exim.php
Find
fn_define('DB_LIMIT_SELECT_ROW', 30);
change the 30 to a higher number, this worked for me.
This is a bug with CS-Cart, it has been going on for years. I opened a ticket before and recently with CS-Cart but never heard back from them. I increased the number from 30 to 100 so less products are being affected.
If you are using default settings and say you have 3000 products, you will not be able to submit 200 of these products.
I wrote a custom fix myself and that's how I'm getting away with it but it requires lots of leg work and server configuration. If you know how to get away with cronjobs, here is my code.
Use with caution, I don't provide support or guarantee that this will work for you, just giving you something to start fixing your feed.