Easy Populate 1.2.5.4 support

In order to do this, is it simply '" . zen_db_input($v_products_quantity + p.products_quantity) . "'

Have you tried this?

I can't really test it, but i'm thinking it might be more like this:

zen_db_input($v_products_quantity + $row['p.products_quantity'])

or

// Put Higher up in code
$existing_qty = $row['p.products_quantity'];

// Then in Statement
zen_db_input($v_products_quantity + $existing_qty)

Seems like it would be better to accomplish this at the spreadsheet level.

*In order to add to products_quantity, is it simply '" . zen_db_input($v_products_quantity + p.products_quantity) . "' *

djdavedawson:

zen_db_input($v_products_quantity + $row['p.products_quantity'])

> 
> or 
> 
> ```php
// Put Higher up in code
$existing_qty = $row['p.products_quantity'];

// Then in Statement
zen_db_input($v_products_quantity + $existing_qty)

Thanks dj,

All 3 suggestions - my 1 and your 2 all overwrite the products_quantity, testing each a couple times to make sure.
What is missing?
At my line 1551, I see that there is a query to get the record's current contents which selects p.products_quantity as v_products_quantity - so it should be drawing current qty and adding the incoming v_ quantity.

I know this may be redundant but try this.

// Put Higher up in code 
$combined_qty = ($v_products_quantity + $row['p.products_quantity']); 

// Then in Statement 
zen_db_input($combined_qty)  

If that doesn't work try this to make sure you're even in the right spot.

zen_db_input(($v_products_quantity + 1))  

// Put Higher up in code
$combined_qty = ($v_products_quantity + $row['p.products_quantity']);
// Then in Statement
zen_db_input($combined_qty)

dj,

Definitely in the right direction. It did overwrite again, but when changing the variable $combined_qty to

$combined_qty = ($v_products_quantity + 1); 

it did just that, starting with a qty of 5 in the upload and added 1 for a total of 6. So it is working. For some reason it's not grabbing the current p.products_quantity and adding, it's only taking the v_products_quantity from the upload.

How about this?

$combined_qty = ($v_products_quantity + $row['v_products_quantity']);

strange. still overwriting.

I tried this too.

$combined_qty = ($v_products_quantity + $row['products_quantity']);

I assume since the sql select statement is pulling the data appropriately it should work. But what if the current data is not recognizable as it wants to overwrite p.products_quantity with v_products_quantity. Seems like it is not possible to draw current products_quantity with Easy Populate?

What happens when you do this?

Find this around 1456:

while ($row){
			$product_is_new = false;

Replace With this:

while ($row){
			$product_is_new = false;
			$existing_qty = $row['v_products_quantity'];

Then in your statement around line 1962

products_quantity="' . zen_db_input(zen_db_input($v_products_quantity + $existing_qty)  

AHA - searching for an existing product!

It looks like we have a winner - thank you dj!

In conclusion, if someone wants to use Easy Populate to mass upload received product (saves us up to 30 minutes per order received)
A. download current quantities. (we have 2 custom fields as well - order point and order quantity - then excel formula what needs to be ordered. I also disregard the formula if doing custom ordering)
B. strip down to 3 columns - v_products_id v_products_model v_products_quantity
C. Save csv for when product arrives.
D. Receive product, make sure you received what is on your csv
E. Upload csv

Use the following code in EP

Find this around 1456:

while ($row){
            $product_is_new = false; 

Replace With this:

while ($row){
            $product_is_new = false;
            $existing_qty = $row['v_products_quantity']; 

Then in your statement around line 1962

products_quantity="' . zen_db_input(zen_db_input($v_products_quantity + $existing_qty)  

You're welcome. :)

Be sure to backup backup and test test test before you rely on this.

I do this kind of thing in excel using vlookup with absolute table refs from one worksheet to another and adding the values all in one column.

Then I just copy the column and 'paste values' right on the of the outputs.

~D

Hello guys, i have an issue and i was wondering if this code will work for my situation. I have an .xls sheet with all my innovatory, fields are like this: Product unique name, product ID, product price, product description, product size (and quantities for that size). Write now i am adding sizes and quantities for each product manually in the data base. I have a lot of products, so naturally its taking me a while to do that. I would like to use some kind of a script that can read product id, product sizes for that id, and product quantities for those sizes, and then export everything in to data base. I have been struggling with this for a week now, any help would be appreciated.

I just installed Easy populate and renamed the admin folder to match my admin folder. When I go to tools there is no Easy Populate option, can someone help me out ?

thanks

is there a uninstall sql or can someone make me one to uninstall all the past versions of easy populate?

The "Download Model/Attributes .csv file " and using it to upload the new product attributes work wonderfully. Unfortunately, it doesn't seem to support the "attribute plus weight," like it does the plus price. Is there something I am missing? I have searched the forums but find no one else needing this. Any assistance would be greatly appreciated!!

Why can i download everything except my products (by name)?

Pretty dumb:

Why can i download everything except my products (by name)?

Becasue I had the wrong version. Sorted now.

I am going to put this out there for conversation. From my view, Easy populate for ZC is no longer user friendly and strictly relevant to coders. I built a few websites using ZC 2 years ago and it was great, but right now I am searching for something else. If you are not a DB guy/girl and do not have a way to bulk upload/download product information, it is worthless.

hi all
how can i download a single product from zen cart using easy populate i have try but i have dowload the etire folder (for 200 products) i have finnised the modifications but i wanna try the upload with a single products iff sommetings goo wrong iff you know what i meen :))
iff sommebody can help me thx

russa2:

I am going to put this out there for conversation. From my view, Easy populate for ZC is no longer user friendly and strictly relevant to coders. I built a few websites using ZC 2 years ago and it was great, but right now I am searching for something else. If you are not a DB guy/girl and do not have a way to bulk upload/download product information, it is worthless.

I can tell you that from looking at Opencart and Prestashop, their equalivents of Easypopulate look much more user UN-friendly, harder to use. Just one look at their spreadsheets and the headings was enough. This is probably the main reason I haven't taken either of these other carts to a live domain.

That and that Zencart now appears to have a much better selection of free templates...and great plugins that in many cases surpass, IMO, those built-in in other carts.

What version of ZC are you using and have you looked at Easy Populate 4 for 1.5.0/1.5.1? I also understand that an earlier version of EP we've successfully used in the past is now 1.5.0 ready.

IOAN:

hi all
how can i download a single product from zen cart using easy populate i have try but i have dowload the etire folder (for 200 products) i have finnised the modifications but i wanna try the upload with a single products iff sommetings goo wrong iff you know what i meen :))
iff sommebody can help me thx

I don't know that you can download a single product with any EasyPopulate version. However, with EasyPopulate 4 you can download a single category.

But if all you want is a single product, why not just edit it in the admin?

Am running into a problem with EP 1.2.5.4 (zc - 1.5)

I've got a database which manages our products, and we've created a dozen or so attribute names, each attribute having anywhere from 2 or 3, up to 20 values.

The database export handles this to a .mer which is converted to a CVS (.txt), for upload & maintenance.

Normally, we open EP, and grab the models/attributes template, which we then can correlate correct field relationships TO, in our database.

We ran into a problem this week, when we added 6 more attribute names and about 15 more values for them, then needed to get the new template, for cross-relating....

When I click the Models/Attributes button (to get a sample), the site runs.....and runs..............and runs.. Eventually it either "glitches" or does something else--but in fact, it reloads the FRONT SIDE page to the site...

I've attempted this on numerous browsers, platforms, have set the retry/timeout settings on browsers out to 5-10 minutes... All to no avaiil.

The window shows the "processing" icon (spinning gear) for right about 3 minutes, then reloads our main front page...
I have tried numerous other ideas - - have monitored the /temp folder to see if iit produces anything, but nothing.....

Any thoughts?

On a parallel note:I would love to move to EP4, but the file format is entirely different (a many-to-many relationship, vs a 1-to-many relationship, where each product has a single entry with all attributes ID'd by # and by price fields)... Is there a way in EP4 to get the same template downloadd, which shows field names?? OR, can EP4 be set up to use the same format as EP 1.2.5.x (ie one record/product per row, with all attributes in that record)?