Easy Populate 1.2.5.4 support

[Sc0rian]

ok.

everything seems to work perfectly..



apart from

under tools i have

BOX_TOOLS_POPULATE

instead of the easy populate link.. and when i click it, it links me too:

admin/FILENAME_POPULATE.php

[Sc0rian]

right im sorry to add another reply..

I believe the above error is there because I'd already installed easy populate, and still have the old link there, which links to it fine. so i'll just have to edit the other one out on the menu, whats the file to do this?

i have just done the exact same thing with my other shop and its gone crazy

i get all this code in the admin section, at the top.. and cant stop it.

[erinl]

[quote=gerhard59;585680]Just started a webshop and added some items manually, exported the list to get the right EP format.
I added the rest of the products and try to import this file.
Record format is correct but I get message "No products_id field in record. This line was not imported" and no products are imported.
record format starts with
"19-10pdu samples/19-8pdu.jpg 19-10pdu powerstrip....etc"
In this case 19-10pdu is a unique identifier connected with v_products_model
The manually added products do get updated whenever I import the file but no new items are added. Images are already downloaded to server.
I use Zencart version 1.3.8 and latest version of easypopulate.
quote]

I have the exact same problem and I have EPA. I entered products without the description manually into zen cart, saved the file, added the description into the file and imported it back into zencart. All I get is the following error message:

Product Import Results
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
Invalid index (products_model) in upload file - This line was not imported - Product - | catalog/2_ | Ergo Diape | | | | | | 60 | 0 | | 18/07/2008 | 0 | Ergo Baby | Sales & Cl | | | Taxable Go | 1 |

I really really want to be able to use EP but so far it hasn't been very successful.

Please help

Erin

www.momandbabyboutique.ca/servlet

[gerhard59]

Thnx, I have downloaded the right version now and decided to start from scratch. My store was still in the making and not yet open to the public.
I will keep you posted about my progress with ZC 1.3.8 and EP1.2.5.4

[Scrat]

Sc0rian : Firstly, its not my mod to place in the downloads area, that would be up to Langer as it is his port from OSC. If you think its misleading then contact a Moderator re the uploads section, I have contacted them to rename this thread so it is for Version 1.2.5.4 to avoid confusion regarding versions to try to help people, as I feel the download section is there for people to post fix's if a mod improvement does not work, as this is a community add-on not a ZC feature.

Secondly to me it looks as you have conflict with your first EP install and your second install of version 1.2.5.4, so you must still have some files installed ?

erinl : Contact Langer as EPA is a commercial product and he does support his product on his website via his forum (and email I think).

[erinl]

Scrat: I'll post my question to Langer - thanks for responding!

Erin

[Sc0rian]

thanks for your reply scrat.

I deleted my whole admin folder and tried uploading a fresh one and tried uploading the workin one out of my other shop. both didnt work..

[gerhard59]

Progress on installation and Easy Populate.
I reinstalled zen cart and easy populate this morning and started testing with my product files. One thing I noticed was EP under Tools was different then before, which was good in my opinion.
Importing still did not work properly. Although all neccesary folders had write access according to dreamweaver (I use DW for other websites and uploading) it turned out this was not true.
After applying the proper rights on the neccesary folders the import is working perfectly.
According to screen it looks like EP is using a different folder for temp.
Whole thing is working like a charm now.

Now it's time to start sales.

[DJMagicCards]

I need Easy Populate 1.2.5.4 to modify the maximum quantity field. I can’t afford the $65 version and I don’t need the other features – I just need maximum quanties. I have tried all I can to get it to work, but it doesn’t. If there is a PHP expert than can give me a tip to get it to work then I would be grateful.

Below I describe what I have tried.

I tried to follow the instructions posted by awev in post #950, but I think his instructions only work for variables stored in TABLE_PRODUCTS_DESCRIPTION.
I believe that max quantity is in the TABLE_PRODUCTS and named products_quantity_order_max.

I tried to modify his method by searching for every instance of “quantity” When I found anything referring to products_quantity I added a line below it and replaced products_quantity with products_quantity_order_max. While I think that is straight forward, it doesn’t work. I get an SQL error. In Admin the message “An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer” is displayed.

Below is what is in the ep_dubug_log

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 '13651")' at line 3
When executing:
UPDATE products
SET
products_price="0.50" ,products_image="Eventid_Batwing_Brume.jpg", products_weight="0.004", products_tax_class_id="1", products_date_available= NULL, products_date_added= "2008-07-25 10:35", products_last_modified=CURRENT_TIMESTAMP, products_quantity="560, products_quantity_order_max="" ,manufacturers_id=7 , products_status=1
WHERE
(products_id = "13651")

The exact steps I took are below: The bold lines are what I added.

Line 392

'v_date_added' => $iii++,
'v_products_quantity' => $iii++,
'v_products_quantity_order_max' => $iii++,

line 460

p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.products_quantity_order_max as v_products_quantity_order_max,

line 485

'v_products_price' => $iii++,
'v_products_quantity' => $iii++,
'v_products_quantity_order_max' => $iii++,

line 500

p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity
p.products_quantity_order_max as v_products_quantity_order_max

line 607

p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.products_quantity_order_max as v_products_quantity_order_max,

line 1290

'v_products_price',
'v_products_quantity',
'v_products_quantity_order_max',

line 1444

p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.products_quantity_order_max as v_products_quantity_order_max,

line 1919

products_weight,
products_quantity,
products_quantity_order_max,

line 1933

'".zen_db_input($v_products_weight)."',
'".zen_db_input($v_products_quantity)."',
'".zen_db_input($v_products_quantity_order_max)."',

line 1970

', products_last_modified=CURRENT_TIMESTAMP' .
', products_quantity="' . zen_db_input($v_products_quantity) .
', products_quantity_order_max="' . $v_products_quantity_order_max .

Any ideas what is wrong?

[fairestcape]

[QUOTE=erinl;586336]

Just started a webshop and added some items manually, exported the list to get the right EP format.
I added the rest of the products and try to import this file.
Record format is correct but I get message "No products_id field in record. This line was not imported" and no products are imported.
record format starts with
"19-10pdu samples/19-8pdu.jpg 19-10pdu powerstrip....etc"
In this case 19-10pdu is a unique identifier connected with v_products_model
The manually added products do get updated whenever I import the file but no new items are added. Images are already downloaded to server.
I use Zencart version 1.3.8 and latest version of easypopulate.
quote]

I have the exact same problem and I have EPA. I entered products without the description manually into zen cart, saved the file, added the description into the file and imported it back into zencart. All I get is the following error message:

Product Import Results
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
Invalid index (products_model) in upload file - This line was not imported - Product - | catalog/2_ | Ergo Diape | | | | | | 60 | 0 | | 18/07/2008 | 0 | Ergo Baby | Sales & Cl | | | Taxable Go | 1 |

I really really want to be able to use EP but so far it hasn't been very successful.

Please help

Erin

www.momandbabyboutique.ca/servlet

If you have categories set up already, you MUST allocate a category (and relative sub-category in your EP file.

See the WIKI for an EP tutorial - search WIKI for Easy Populate.