Easy Populate 1.2.5.4 support

[chadderuski]

I get data from my vendor in a completely different order than in the easy populate column format. Does easy populate just look for the header names in the column?

Put a different way it would be far easier for me to take my data form my vendor, chop out a column or two, label them with the easy populate column names and import than try to paste the vendor data in in the order that the columns appear in the template for easy populate.

Does the order of the columns matter or does the import script just look for the column names regardless of order?

If you are using 1.2.5.4, order should not matter except perhaps for the categories. EP processes by column headers. You will need the EOREOR column.

[chadderuski]

Thank you for reply I have changed max_execution_time = 360 it is still not working . Please help again

your host may be limiting you and killing the process despite your over-ride.
try to break the file up into smaller chunks, say 2,000 a pop and increase until you start to time out again.
else contact your host and trouble shoot with them.

[chadderuski]

There is one EP version that does upload and insert product attributes even when they do not already exist. We got it here some time back, but I just re-downloaded and notice that most of the files are no longer in the download:

http://www.zen-cart.com/index.php?ma...roducts_id=460

This has been the most reliable EP I've used. I recently installed it on a brand new zencart/domain...no data base sql to insert:

www.fashion-mart.biz

I uploaded product colors the other night, inserting them when they did not exist. (You do have to assign an attribute id no.) As I recall, with "regular" EP versions, you had to manually enter the attributes into the admin before uploading the product/attribute sheet.

This EP version is also great in that you can DOWNLOAD by category...don't have to be all or nothing.

Only thing is, it didn't generate the attribute spreadsheet properly. We found out that we could use the attribute spreadsheet generated by regular EP 1.2.5.4.

Anyway, I'm here at EP thread as I need a meta tag sheet, so I'll install a "regular" EP version on a test site to get the download sheets.

I would be interested in the EP that apparently allows one to insert additional fields in the admin. Would that work for the CEON URL Mod I wonder?

sph

my beta version supports product and category meta-tags and also multi-lingual category names. it installs independently of other EP versions, and also has download filters.

i completely rewrote chunks of code, hacked out much garbage and archaic code, cleaned up and fixed many known bugs, and combined good code and ideas from several coders:
original OSC version, langer, phazie (spelling?) and myself. jrobeson at github also had a sophisticated version, but I believe it's requires zenmagik now.

i wrote attribute handling from scratch (some inspiration from "Attributr") ... still not quite done!, re-wrote and re-conceptualized category importing to support languages and meta-tags.
added many useful fields, and also wrote category-breaks. oh, and two custom fields for price_uom, and products_upc.

still needs spit and polish, and attributes to be rounded out for completion. there are several problems with zencart's attribute model that make importing and creating attributes from
scratch a challenge, so I do have a limitation or two that I spell out in the documentation. there is a logical way to solve these problems, but would require major core file changes involving
attributes.

give it a try, perhaps you'll like it!

-cj

[OhSoNew]

So I finally figured out how to install Easy Populate (YES!!!). Now I have a question regarding how to populate.

My vendor has files that I can download to import and they say I can also use as a data feed, but do not know how. Here is my issue. There are 4 files.

File 1 is an excel file with the current price list with product, weight, price.

File 2 is an excel file with newest items only with product, weight, and price.

File 3 is an excel file with product description including category and image file name (category section is one column with categories separated by commas).

File 4 is a pipe delimited options and attributes of the products.

Then there are numerous image files.

So, my problem is I do not know how to configure it all to import with EP.

Am I supposed to configure each of these files myself to follow the v_... that EP says to do or combine them all into one file or what? Or am i to use them as a data feed and if so how?

I am absolutely clueless how to do this and need as much help as I can get.

Thank you,
Lee

[schoolboy]

I am absolutely clueless how to do this and need as much help as I can get.

Thank you,
Lee

Have you seen my WIKI tutorial?
http://www.zen-cart.com/wiki/index.php/Easy_Populate

[OhSoNew]

Schoolboy,

Yes, I read through the entire wiki tutorial and it is helpful. I get the basics how it works, but my vendor having 4 separate files throws me off.

If one file only has the product model, name, weight, and price and I import that, i'm missing the description and category. So how would I get that part from the other file in there? Am I just uploading all 4 files and easy populate just matches all the information up?

Also, their category column is different. It lists their categories like (wedding, wedding-favor, paperweight...) it is one category column with the categories separated by commas. Do I have to delete that and make my own categories using v_.... or will Easy Populate read that category column with the columns and set it up accordingly?

Also, that one pipe delimited text file with the options and attributes is confusing. It opens in notepad and just has (A|EB1037|label_type|radio|<strong>Label Type</strong>|0|0|1|||1|0) and when opened in excel it shows the same thing all in one column, so how do I import that file with EP?

Like I said, I am just new to all of this and am just having a hard time understanding how this works, so any step by step or dummied down instructions you could give me would help. I went through the tutorial and everything made sense, and then I saw my vendor's files and all the sense went out the window. Please help!

Thank you,
Lee

[schoolboy]

OK... here's the beef...

1. Easy Populate is relatively INFLEXIBLE when it comes to the format of the EP upload file. It has to have a certain structure, and some fields are obligatory - my Tutorial highlights all of this.

2. So forget about EP at this point... your PRIMARY challenge is getting all the data (currently in a mish-mash of csv and "pipe" delimited formats), into one single file.

This requires a knowledge of spreadsheet formulae, and you will need to do a variety of (possibly detailed) cross-lookup functions, and possibly even a pivot function or two, to get the different spreadsheets to "amalgamate".

Unfortunately, this is not a zencart issue, and you would be better getting help on forums that discuss the operation of formulae in spreadsheets.

You will not be able to begin the structuring of the EP sheet until you have merged all relevant data.

[schoolboy]

... I would add that you should kick your supplier in the a$$ and insist they provide the data in a way you can use it.

Generally they can... all they need to do is configure and export using the fields you require. If they are using SAP, or something similar, getting it to output a report (export) is not that complex.

They may tell you "it's not possible"... but don't roll over to have your tummy scratched. BARK LOUDLY at them and tell them that THEY will benefit (from sales) just as much as you will, so it is in their interests to assist you.

[OhSoNew]

Thank you. At least i'm not super crazy in thinking them putting 4 different files is dumb. Nonetheless, I did attempt changing the column headings on the product description file and imported and it did work. However, it appears it is going to be quite a challenge as I will have to compile my own category columns as theirs is BS, which means a lot of work figuring out categories for 400 plus products that can go into multiple categories (for example one product can go into wedding favors, baby showers, bridal shower category etc.). This is just too time consuming.

Then there is the matter of products having multiple pricing tier. For example, one product can be purchased in different quantities. If they buy 1-11 products each price is XXX. If they purchase 11-20 the price is XXX. How would that work? The quantity with respective pricing is in the excel sheet, but how would I label the columns to have EP import that information?

It is just too much. Is there anyone out there willing to do this and I will pay? lol Seriously.

[DaMixa]

Hi ,
I get this 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

and I think I know where Ive gone wrong.

Ive added 4 new fields to the database :

products_supplier_code
products_gb_code
products_price_markup
products_priceWS

and tried to reference them all in EasyPopulate.php, but I think I have the following part (the update (insert into or update) part) wrong...would one of you wizards please check for me and Ill magic a pint of beer over for them!...Thanks.

code is: (my additions are in red)

$query = 'UPDATE '.TABLE_PRODUCTS.'
SET
products_price="'.zen_db_input($v_products_price).
'" ,products_image="'.zen_db_input($v_products_image);
// redundant image mods removed
$query .= '", products_weight="'.zen_db_input($v_products_weight) .
'", products_supplier_code"'.zen_db_input($v_products_supplier_code).
'", products_gb_code="'.zen_db_input($v_products_gb_code).
'", products_price_markup="'.zen_db_input($v_products_price_markup).
'", products_priceWS="'.zen_db_input($v_products_priceWS).
'", products_tax_class_id="'.zen_db_input($v_tax_class_id) .
'", products_date_available= ' . $v_date_avail .
', products_date_added= ' . $v_date_added .
', products_last_modified=CURRENT_TIMESTAMP' .
', products_quantity="' . zen_db_input($v_products_quantity) .
'" ,manufacturers_id=' . $v_manufacturer_id .
' , products_status=' . zen_db_input($v_db_status) . '
WHERE
(products_id = "'. $v_products_id . '")';
$result = ep_query($query);
if ($result == true) {
$display_output .= sprintf(EASYPOPULATE_DISPLAY_RESULT_UPDATE_PRODUCT, $v_products_model);
foreach ($items as $col => $langer) {
if ($col == $filelayout['v_products_model']) continue;
$display_output .= print_el($langer);
}
} else {
$display_output .= sprintf(EASYPOPULATE_DISPLAY_RESULT_UPDATE_PRODUCT_FAIL, $v_products_model);
}
}