Easy Populate 1.2.5.4 support

sorry i mean i am switching 1 to 2. not product id. but the product type.

I used easy_populate free from langer modhole_v1-2-5-5.
All worked fine for me until when i uploaded the .txt data file to another cart.

All categories/products were impoted correcltly but when i switch to the french language none of them shows in the category tab.
But all of them shows in the all products,featured products link.
The category tab remains blank.

But all is working fine in English.

You can see through this link :http://lockdownsurveillance.com/

dhanesh:

I used easy_populate free from langer modhole_v1-2-5-5.
All worked fine for me until when i uploaded the .txt data file to another cart.

All categories/products were impoted correcltly but when i switch to the french language none of them shows in the category tab.
But all of them shows in the all products,featured products link.
The category tab remains blank.

But all is working fine in English.

You can see through this link :http://lockdownsurveillance.com/

would you please let me know where you got the 1.2.5.5. version?

Can someone guide me in the right direction on how to use easy populate on the attributes, Basically i have edited all the descriptions and changed the price but the attributes were not included, so I seperatly downloaded the attributes but it didnt really make any sense to me. Thanks

dhanesh:

... but when i switch to the french language none of them shows in the category tab.

But all is working fine in English.

I've read in the many posts in this thread about language problems. I do not use any other than english, but the upload code for languages is around line 1660 in easypopulate.php. It appears to be somewhat documented in the code.

Jeff

ben harry:

Can someone guide me in the right direction on how to use easy populate on the attributes, Basically i have edited all the descriptions and changed the price but the attributes were not included, so I seperatly downloaded the attributes but it didnt really make any sense to me. Thanks

I'm working on a site with lots of option names and values. I could not get it to work without heavy mods to the code.

My workable (for me) solution is 2 files. File 1 is everthing except the options. File 2 is only options.

You need to stop the main loop from updating when doing file 2. I did "if v_desc is null" type of thing.

I also put each option name/value combination on a separate line. So if a product has 4 options with 4 values each, I have 16 lines for that product in file 2. Code mods needed for this need to remove assumption that each line is not the only.

Some issues I have are when updating options. Currently no way to delete existing before creating new.

It was not a trivial task for someone that does not know php. Mostly trial and error.

Hope this gets you in the right direction.

Jeff

Hi - I am having the same problem as credenscel, above.

I created a new product type, a chemical, based on the book mod. Which works. I used the free EP to test load 5 items. Which worked. BUT altho they appear in the store, in admin/editproduct, the data does not appear, and I get this error:

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/capralog/public_html/storefront/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/capralog/public_html/storefront/admin/includes/classes/object_info.php on line 30

I changed, manually with phpadmin, the product type to be '7' which is what it is. (Easy populate brought them in as '1'.) Is there anywhere else that product type needs to be changed so these products appear in the edit screen?

Hi All,

The latest version from the downloads section is v1.2.5.5 is this ok for version 1.3.8?

Cheers

Brett

When i upload the EP file from another cart i get this message:

Warning: file(/home/lockdown/public_html/temp/Full-EP2008Oct03-0808.txt) [function.file]: failed to open stream: No such file or directory in /home/lockdown/public_html/admin/easypopulate.php on line 1201

Warning: Invalid argument supplied for foreach() in /home/lockdown/public_html/admin/easypopulate.php on line 1301

Can anybody suggest why this happens?????

an almost-solution to my post, #1928, above.
The reason I was getting that error was because EasyPopulate does not add its products to the product-book-extra table.
(background: I made a new product type, not a book but based on the book product type info. Then I used EP to load the data. Products did show in the store, not in the back-end admin within the new product type page.) Reason was it was never loading in the collect_info.php program - because that file's SELECT statement failed because it was looking for data in product_book_extra - and lo - EP never wrote anything to there, of course, and nothing was there.

Because I'm not a php wizard, instead of modding EP to write even a product_id# to product_book_extra, I used phpadmin to load a csv file of the product-id's (generating that file by exporting it using phpadmin).
I hope this is somewhat clear and helps someone who is wondering why their custom product-type products aren't showing up in the admin edit product screen.

would you PLEASE let me know how exactly you load a csv file to make EP work with alternate product types? I dont know how to create/load a csv file and your help will be much appreciated!

I am using music product type and have been looking for a solution for some time now.

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?

Did anyone figure out what DJMagicCards did wrong or needs to do to get this to work?
I get the same error when I tried to do this??
Any help will be appreciated.

Mack32

Anything above line 1270 does not matter for the upload.

line 1290

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

This looks right. The new column in your sheet should have heading '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,

This looks OK.

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)."',

These 2 sections look right and should give a successful insert of a new item includeing the new column

line 1970

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

Here's your problem! I think this would not do a proper update. I believe the line should be...

'", products_quantity_order_max="' . zen_db_input($v_products_quantity_order_max) .

The zen_db_input says it is a variable and was left out. The quote mark at the beginning is needed to close the quote from the above line.

Give it a shot!

Jeff

Thank you jeff

That did it. I uploaded a small file to see and it works.

Thank you soooo muuuuch! :clap:

Mack32

Glad to help when I can.

ok, I installed EP, exported list, updated weights, now, do I simply Upload EP File? Will it overwrite the current database? I just want to make sure it will not double our DB or have some other strange problems. Just need some re-assurance that this is as simple as it seems.

You need to make sure that the model numbers for the items you're updating match up with the ones already in your system.

Otherwise, EP will treat them as new items.

If something goes wrong, you can always download the new catalog tab-delimited file, and change v_status from 1 or 2, to 9, and that will delete whatever is in that row. Change v_status to 9 for all items you wish to get rid of.

-Tim

yelow:

You need to make sure that the model numbers for the items you're updating match up with the ones already in your system.

Otherwise, EP will treat them as new items.

If something goes wrong, you can always download the new catalog tab-delimited file, and change v_status from 1 or 2, to 9, and that will delete whatever is in that row. Change v_status to 9 for all items you wish to get rid of.

-Tim

Tim,

thanks for your quick reply!

the only thing we changed was the weights so they will work with shipworks.

also, we have 3000 products, so I don't want any issues... so do you think we are good to go?

Hi There
I have just downloaded the complete Full-tab delimited.txt file and it appears not to have extracted all the information from the database. The v_products_url_1 field is empty. Is this field meant to be empty or should it show the url for each of the products.

I do recall way back, when I first downloaded the mod that when I did an upload of only a few new products, the system didn't generate a product url. All other information was created as I could see the products in the admin but couldn't actually navigate to the products on the storefront, as there was no product url allocated for each of the new products.

Does anyone have any idea as to what may have went wrong or advise me as to how ep is suppose to work so that I have a better understanding.

TIA

keylesslocks:

ok, I installed EP, exported list, updated weights, now, do I simply Upload EP File? Will it overwrite the current database? I just want to make sure it will not double our DB or have some other strange problems. Just need some re-assurance that this is as simple as it seems.

Just be sure to go to tools/backup mysql database before loading every new EP file.