EasyPopulate 4.0 Support Thread

[chadderuski]

Chadd,

ZC 1.5, this product:
http://www.webdivision.prommart.com/...roducts_id=191

We think we know how your Basic Attributes work.

But we probably really need the Detailed Attributes sheet to do our V-Lookup thing off of the column headings I mentioned some months ago.

I guess my question is: Can I use the Detailed Attributes sheet to ADD another color to this product? If so, how.

I tried and think that I am stuck on column A...v_products_attributes_id

I tried adding what should be the next number in order, but didn't work.

Thanks.

Steve

Hi Steve,

First, from an earlier post:
One this that is important to remember!

The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.

But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.

You cannot use the detailed sheet to add colors. What you'd do first is run the basic with the products model number and options name to add options values name.
Then export your detail sheet which will now have all the colors assigned to that products.

Does that help to clear things up?

[jandm-ent]

we are having a problem with Quantity Units errors after updating our qty in stock via easy populate. So far the only way we have been able to find to fix the error in through the catalog in the admin section, going into every item individually and updating them. This is not reasonable for us as we have 16,000+ items. Is there any way to fix this or are we doing something wrong?

Easy populate 4
Zencart 1.5

[chadderuski]

we are having a problem with Quantity Units errors after updating our qty in stock via easy populate. So far the only way we have been able to find to fix the error in through the catalog in the admin section, going into every item individually and updating them. This is not reasonable for us as we have 16,000+ items. Is there any way to fix this or are we doing something wrong?

Easy populate 4
Zencart 1.5

I have tested this and do not believe it is a problem with the script. Also, you did not describe what error you are getting. Have you done an export with a small sub-category, downloaded it, changed the v_products_quantity column, resaved as CSV and uploaded/imported to see if the values recorded correctly?

I just did this, and it worked find. Now, if your column header is "v_products_quantity " <--- see that extra space? That will kill the column, and it will not import.

General note to all:
When having issues like this it really helps to attached a portion of your import file. And when testing, don't start with a massive import! First verify that you know your columns are working correctly by importing only a couple records, then carefully check each record's entry for accuracy. I have done this literally hundreds of time.

Now, most times it's the CSV data, but sometimes it's the script. So you should always include the version number in your posts. You should all update to 4.0.21 because of the mixed update/new data error I discovered when importing sheets with reduced columns (that had to have been in there for sometime!) ... along with all the other corrections and tweaks.

-chadd

[chadderuski]

did not work
followed post 205
Here is what I did.. Trying to impout a hidded field "Cost"

easypopulate_4.php

line 102
$ep_supported_mods['Cost'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_Cost');

*********************

easypopulate_4_import.php

line 30
if ($ep_supported_mods['Cost'] == true) { // Cost - chadd
$default_these[] = 'v_products_Cost';
line 322
if ($ep_supported_mods['Cost'] == true) { // Cost- chadd
$sql .= 'p.products_cost as v_products_Cost,';
line 936
if ($ep_supported_mods['Cost'] == true) { // Cost
$query .= "products_Cost = '".addslashes($v_products_Cost)."',";

line 1025
if ($ep_supported_mods['Cost'] == true) { // Cost
$query .= "products_Cost = '".addslashes($v_products_Cost)."',";
*************************

easypopulate_4_functions.php


line 79
if ($ep_supported_mods['Cost'] == true) { // Cost
$filelayout[] = 'v_products_Cost';

line 160
if ($ep_supported_mods['Cost'] == true) { // Cost
$filelayout_sql .= 'p.products_Cost as v_products_Cost,';

any help or link to a tutorial would be greatly appriciated.

Believe me, something as simple as a misplaced single or double quote or missing parenthesis can drive you bonkers, not to mention 5-way inner joins on sql database queries.

Trying to quote the code doesn't help. You left out parts. Better to PM or attach the files so I can look at your work. I bet I can spot the error quickly. Believe me, I fudged things up enough myself in the beginning! It's easy to do.

-chadd

BTW: use phpMyAdmin and double check your table column's name products_Cost <> products_cost in some implementations.

[awhfy99]

I did notice a couple of things that I would like to see changed, if possible. I have been using it for several months and checking the posts to see if they were mentioned there. If I missed them, my apologies in advanced and I will download it again.

The specials fields are pre-populated with an expiration date when none is set. This requires that field to be cleared before uploading or your specials will all be expired.

The other thing I noticed is that the down-loaded products default to status 1, so if you need both the 0 and 1 statused items, you will need to download the products twice. This is a small hassle when changing quantities and restocking at the same time.

Otherwise, this is one of the best contribs that I have found!

[chadderuski]

The specials fields are pre-populated with an expiration date when none is set. This requires that field to be cleared before uploading or your specials will all be expired.

I will have to look into this one. Didn't know it was doing that!

The other thing I noticed is that the down-loaded products default to status 1, so if you need both the 0 and 1 statused items, you will need to download the products twice. This is a small hassle when changing quantities and restocking at the same time.

This should be fixed in the 4.0.21 6-1-2012 currently at github! Definitely update to the latest version for other minor fixes.

PLEASE NOTE: CUSTOM PRODUCT FIELDS coming soon!

I've had several requests to add the ability to define custom products fields. This turned out to be quite easy, and will be in the next version pushed to github. I added a configuration field where you can enter your products table fields (existing or custom) and the script checks for them before exporting/importing so you know you entered them correctly.

Needs a bit more testing, but should be able to push in a couple days.

-chadd

[johnn196703]

I will have to look into this one. Didn't know it was doing that!



This should be fixed in the 4.0.21 6-1-2012 currently at github! Definitely update to the latest version for other minor fixes.

PLEASE NOTE: CUSTOM PRODUCT FIELDS coming soon!

I've had several requests to add the ability to define custom products fields. This turned out to be quite easy, and will be in the next version pushed to github. I added a configuration field where you can enter your products table fields (existing or custom) and the script checks for them before exporting/importing so you know you entered them correctly.

Needs a bit more testing, but should be able to push in a couple days.

-chadd

Hi,

I tried to import option names and option values, and I saw them imported via admin. When I click on each product to view it on the product infor page, I did not see any option names as well as option values displayed.

Below is a link to my file. Please take a look and give me your advice. Thanks!

http://www.theladystuff.com/temp/DD.csv

[chadderuski]

Hi,

I tried to import option names and option values, and I saw them imported via admin. When I click on each product to view it on the product infor page, I did not see any option names as well as option values displayed.

Below is a link to my file. Please take a look and give me your advice. Thanks!

http://www.theladystuff.com/temp/DD.csv

Hi John,

To use the attribute feature in EP4 you need to first import your products using the Full sheet. You will then create a Attrib-Basic-EP csv file with columns:

v_products_model, v_products_options_type, v_products_options_name_1, v_products_options_values_name_1

Also EOREOR is not required with EP4. And file naming conventions must be followed otherwise the script will not know what to do with the file.
Check the examples folder for more information in the attribute_types.txt file and a sample basic attribute import csv file.

-Chadd

[Terrill_Taylor]

Hello -

I'm a brand new user to EP 4, and my cart has been recently upgraded to 1.5. I'm trying to wrap the product description in DIV tags it appears that the import is adding a ? where there should be a space within the html tag. So the tag is <div class="info-text"> but when I look at the page source (or edit the html of a freshly imported product) it appears like this <div?class="info-text"> --- I was initially using excel. So I opened my csv file with notepad to see if the output was adding the ? - the ? wasn't present. I also tried generating the csv file with OpenOffice Calc -- same result.

Any ideas?

[chadderuski]

Hello -

I'm a brand new user to EP 4, and my cart has been recently upgraded to 1.5. I'm trying to wrap the product description in DIV tags it appears that the import is adding a ? where there should be a space within the html tag. So the tag is <div class="info-text"> but when I look at the page source (or edit the html of a freshly imported product) it appears like this <div?class="info-text"> --- I was initially using excel. So I opened my csv file with notepad to see if the output was adding the ? - the ? wasn't present. I also tried generating the csv file with OpenOffice Calc -- same result.

Any ideas?

Be sure you are not using smart quotes in your csv, or go to Configuration > Easy Populate 4 and set "Convert Curly Quotes" to 1 which will replace smart quotes with a regular quote.

I tested this on my end using your example and it worked fine....