Easy Populate 1.2.5.4 support

[schoolboy]

Hi

I normally find the answer to any problems I have in this forum, but this time I haven't had any luck.

I use Zent Cart v1.3.9d + Easy Populate 1.2.5.4
I haven't made any changes between Easy Populate working and it playing up. My site has been running for over a year.

I thought EP was not working at all at first, but after investigating I realized it will amend existing products but will not add new ones.

UPDATED! - Model: 100001 | Saa_og.gif | Skill at A | Skill at A | | | | | 1.75 | 0.003 | 1 | Garrison P | Qualificat | | | | | | | Taxable Go | 1 |
UPDATED! - Model: 100002 | Saa_og.gif | Skill at A | Skill at A | | | | | 2.75 | 1.003 | 1 | Garrison P | Qualificat | | | | | | | Taxable Go | 1 |
ADD NEW PRODUCT FAILED! - Model: ma073 - SQL error. Check Easy Populate error log in uploads directory

If anyone can suggest what I should try to fix this I would be very grateful.

Again... simple READING tells you:

Check Easy Populate error log in uploads directory

[MrsDusty]

I have pasted the error log below, but I have no idea what it's telling me.

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''
products_quantity,
manufacturers_id)
VALUES (
'' at line 11
When executing:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity_order_min'
products_quantity,
manufacturers_id)
VALUES (
'MA073.jpg','MA072',
'1.8333',
'1',
CURRENT_TIMESTAMP,
"2010-07-15 19:30:00",
NULL,
'1',
'0.001',
'2',
'1000',
'17')

[MrsDusty]

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR
ma073 MA073.jpg ITW Grimloc GhillieTEX IR signature reduction technology. Corrosion resistant stainless steel spring. Self purging ports to prevent sand blockages. Attaches to 1 inch webbing. Textured grip for use with wet/gloved hands. Lightweight: 0.01 kg 3.75 1 1 Garrison PRI Qualification Patches Taxable Goods 2 EOREOR

[schoolboy]

It might be that the insert statements lack a final delimiter...

Line ELEVEN is the final line:-

'17')

The last line should have a semi-colon as the delimiter

'17';)

Just why it is not inserting the delimiter is not something that can be answered without knowing a lot more about your setup.

Perhaps DrByte will chance on this thread and offer us possible reasons. It could be that your EP files have become corrupted.

You might be able to rectify the issue by loading fresh EP 1.2.5.4 files via FTP.

[MrsDusty]

Thank you. I will try a new upload of EP and see if that helps.

[MrsDusty]

It could be that your EP files have become corrupted.

You might be able to rectify the issue by loading fresh EP 1.2.5.4 files via FTP.

You were spot on. A new install and it's behaving like a dream.

[100asa]

I apologize if the question has already been done, but I can not find it.
My site2 is the mirror of site1; some products on site1 was deleted, and when I import data on site2, the products deleted on site1 still remain alive on site2. Is there a way to delete (or mark as red) the products that not imperted from site1? I hope I'm clear

No one suggestion for my trouble? Must I full delete my sql products table and then import by easy populate?

[schoolboy]

No one suggestion for my trouble? Must I full delete my sql products table and then import by easy populate?

Product information is put in MANY places in the database.

You should use Easy Populate to create a DOWNLOAD of all your product data.

Then, to DELETE product data, you edit the spreadsheet to change v_status to 9 for all products you want to delete. Then you "run" that file through easy populate.

[Alexiss]

Hello I am using easy populate but for some reason when you load the file prices that have a value example $2,520.99 will load on my site as $2.00. It seems to me that easy populate sees the Comma (,) in larger numbers as a decimal point.

Any suggestions Please,


Thanks


Lexxie

[rolo550]

I can't teach you how to read... but your error says:

"No category provided for this product"

Seriously... you can't get a more simple report than that...

My tutorial illustrates how category issues are handled.

I don't understand why everyone has to be such a smartass in this forum. I looked over your tutorial searching for category and categories and its just general info with "fix it" if you get errors...

If one looks at the file i pasted in, one will see that I have clearly defined a category column...so that leaves us with why is it not being pulled in...I realize its says "no category" in the error, but why? I have the categories name column in my file and every single product has a category assigned...