Easy Populate 1.2.5.4 support

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);
}
}

In what TABLE did you add these fields? They may need to go into the products table.

Then, look at the post by LANKEEYANKEE that shows how to ADD FIELDS TO EASY POPULATE (search for that thread.)

If, after following his method, you still get errors... ask your vicar to seek help from a higher authority...

Problem solved...(I think) I didnt follow this:

http://www.zen-cart.com/forum/showthread.php?t=57924

Sorry Schoolboy didnt see your response.
Ive added all fields in product table, I have them all working now apart from one thing.
One of the fields is wholesale price, one is a % field. The price field is populated by a formulae between these fields , basically giving a , say, 25% markup on my wholesale price. now THATS the bit I cant get to work yet.

I have all field showing on admin so I can add one test product in Admin with all the fields, then I download an ep file with the one product in. When I add another product in the EP txt file and try to upload it it gives the SQL error and suggests I look to see if I have any spaces in my cells (or something like that)...

Sorry if that makes no sense at all, Ill post the solution when I find it!:frusty:

Thanks Again

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.

Hiya OhSoNew!

I think that I can help you with your multiple issues, but you would need to use my EP4 beta version. I call it beta, but it's very stable. I have several avid users doing 100K item imports/updates with it... but they probably are on either a VPS or running a full server. I can help with the tier pricing (which I wrote myself), categories in one field, and I have a "way" to do linked products that seems to work okay ... as long as you work within restrictions.

Also, there is a cool little Excel script that I use for doing things like sorted matched merges on multiple tables provided you have a common column to key on.

Please send me a PM. Your issue is too complicated to solve in this forum and I'll need to see your data. You can install EP4 along with 1.2.5.4. They are completely independent, so you won't break anything doing so.

https://github.com/chaddro/EasyPopulate-4.0

LOL! Schoolboy! My day job just made the move to SAP! The stories I could tell about the cluster-fudge this move has been!

-cj

Okay I think this is the right place to post my question. I have the files in the /temp/ folder of my site but I can't import them using EP. i just keep getting reverted to the login screen. I have tried switching browsers AND refreshing my cache, I look and I don't see any errors in the error log. I am not sure what to do. I am on a linux server and both my admin and temp folders have 755 permissions.

autumnlights:

I have the files in the /temp/ folder of my site but I can't import them using EP.

What files are you talking about and how did they get there?

Does temp have 777 permissions?

yes temp has 777 permissions and its the .txt product files the sample ones and the one that I uploaded using FTP from my vendor. I can't get either to load on a linux server.

autumnlights:

yes temp has 777 permissions and its the .txt product files the sample ones and the one that I uploaded using FTP from my vendor. I can't get either to load on a linux server.

Are you using https for all your admin access?

I believe ep 1.2.5.4 has problems when you set your admin to https and results in kicking you back out to login.

try changing your config.php for your admin and remove https.

let us know how that works.

i uninstalled and reinstalled everything. I ran it on my other server that's powered by Debian (I have two hosting sites) and it was able to upload the files but nothing populated to the tables. I manually broke the files up and got the same problem. I think there is a functionality issue with running on Linux with Hostgator but iPage I had no problem's uploading on Debian.

In regards to my previous question, I have crafted a solution together. For those of you who are trying to use easy populate with products with attributes - it seems that EP operates like this when uploading:

Step 1: Delete all items (and their attributes) from the database.
Step 2: Insert all items into the now 'empty' database, and set them active by default.

The issues with this are that:

(A) All inactive items are set active - and status isn't included in the attributes download - therefore items you have inactive (say for records/bookkeeping purposes) are set active and there's no check to set them as inactive.

(B) If you have products priced by attribute, you will have to turn around and manually set each item's default attribute or you will end up with order for items that total $0.00

How I fixed this:

Search for:

if ($products_with_attributes == true) {
//include attributes in full download if config is true
// VJ product attribs begin

> 
> And change "true" to "false"
> 
> (In my file it was around line 400)
> 
> What this has done, is force the attributes to be included in the full download (The one that says "Attributes Not Included"), so you can update their status, their attributes, etc. without having to download/upload two files.

> **Search for**
> 
> ```php
	$attributes_clean_query = "delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$v_products_id . "' and options_id = '" . (int)$$v_attribute_options_id_var . "'";
	ep_query($attributes_clean_query);

And comment out those two lines of code.

(In my file it's around line 2180)

What this does is it kills the whole "Let's delete all the data and start fresh, even though we're not going to update the default_attribs value" process.

While there is most likely a multitude of ways to do this...this is the way I was able to finally get it to work. I have minimal amount of PHP knowledge to still be able to say "Yeah...I know some PHP", and the file I have to work with was already heavily customized. (There are entire BLOCKS of code that have been commented out, as well as what seems to be a running conversation in parts of the file via comments as well.) So this has been one frustrating experience. I hope to relieve some of the frustration others might experience.

Help!!!

I have done something very silly!! I have uploaded an old txt file in error and now it has updated and added files going back to June.

I don't have any recent txt files and wondered if anyone knows how to restore what was in my previous backup if this is possible. I have no idea where to start.

I really hope someone knows the solution otherwise I will need to go through all of my items and check each one individually :no:

Thank you!!

I apologize if the question has already been done, but I can not find it.
My site2 is the mirror of site1; some products on site1 was deleted, and when I import data on site2, the products deleted on site1 still remain alive on site2. Is there a way to delete (or mark as red) the products that not imperted from site1? I hope I'm clear

I have installed the EP, but when I click on it under the tools, it is just a blank page. And when I click on it under the configurations, it is a blank page with headers.
What is wrong with it? I am missing something?
I was not successful installing manually, so i did the sql ptach, and still did not work.

Any ideas will be greatly appreciated.

Thanks

drago:

I have installed the EP, but when I click on it under the tools, it is just a blank page. And when I click on it under the configurations, it is a blank page with headers.
What is wrong with it? I am missing something?
I was not successful installing manually, so i did the sql ptach, and still did not work.

Any ideas will be greatly appreciated.

Thanks

I haven't used Easy Populate for awhile until now because Apsona isn't working on my new server.

But, it sounds like all you files didn't upload correctly. I'd try uploading them again and then check.

Hope that helps.
Gary

Thank you sir.

That worked just fine. I think i was missing something.

But my next question is... I able to upload, it says new product in green, however, when i look at the site there is nothing there, and nothing on the products tab on the admin. But the interesting thing is that a new category was created.
Am I missing one step?

so I feel liek my importable file is ok, but all I get is a pile of errors

like

SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 5.11 THU | Holsters | 51.6 | 1 | 26 | Thumbdri | 5.11 Tacti | 50023 | | 5.11 Tacti | 511-50023_ | Taxable Go | 1 |

When trying to import - on every single item...nothing imports...using the browse to file/upload option

Attached is a data sample....

rolo550:

so I feel liek my importable file is ok, but all I get is a pile of errors...

http://www.zen-cart.com/wiki/index.php/Easy_Populate

Thanks for pasting in the link, but what are you trying to tell me? I was told column order didn't matter...is that what my issue is and you are trying to tell me?

I'm grateful for your taking the time to read my post but a little more specific pointer could be helpful

Hi

I normally find the answer to any problems I have in this forum, but this time I haven't had any luck.

I use Zent Cart v1.3.9d + Easy Populate 1.2.5.4
I haven't made any changes between Easy Populate working and it playing up. My site has been running for over a year.

I thought EP was not working at all at first, but after investigating I realized it will amend existing products but will not add new ones.

UPDATED! - Model: 100001 | Saa_og.gif | Skill at A | Skill at A | | | | | 1.75 | 0.003 | 1 | Garrison P | Qualificat | | | | | | | Taxable Go | 1 |
UPDATED! - Model: 100002 | Saa_og.gif | Skill at A | Skill at A | | | | | 2.75 | 1.003 | 1 | Garrison P | Qualificat | | | | | | | Taxable Go | 1 |
ADD NEW PRODUCT FAILED! - Model: ma073 - SQL error. Check Easy Populate error log in uploads directory

If anyone can suggest what I should try to fix this I would be very grateful.