Printable View
Version 1.2.5.4 shows compatibility with ZC 1.36 Tearing down my whole store with mods and all isn't much of an option. I don't want to take the chance of messing other mods or store functionality up by such a downgrade. Since there is no official 1.2.5.6 thread I assumed this is the best place to come since all the EZ Pop wizards are here.Quote:
Originally Posted by misty
So does anyone mind taking a crack at my Duplicated Manufacturer issue?
Yes, and also works with ZenCart 1.3.8.a, which is whyQuote:
Version 1.2.5.4 shows compatibility with ZC 1.36
suggested it, because version you have installed is not
as stable.
You most certainly have something different in the manufacture's name ... even an added space at the end will cause a duplicate, ie:Quote:
Originally Posted by gecko77799
"Libbey" vs "Libbey "
Manufacturer's are also case sensitive:
"Libbey" vs "libbey"
This issues is also evident in Category names.
What EP version are you using? The 1.2.5.6 CSV version?Quote:
Originally Posted by NickPCs
(I personally don't use these newer "csv" versions as they appear to be a bit buggy).
Your v_products_price...
$35.61
$341.76
$341.80
$335.07
$341.80
$341.80
$30.65
$169.33
$299.06
$347.04
You are including a $ symbol before the price. This column should just be the numeric value - NO currency symbol.
Well to me I thought the froogle code would be a happy bonus, as I don't have anything like it in my cart yet. But it appears to be severely outdated as froogle is now the Google merchant center or something like that. Looking through the docs there it would appear that the feed this produces isn't exactly compatible.Quote:
Originally Posted by chadderuski
So as it stands now it seems broken. If it were to be fixed to work with what Google now offers I would definitely use it.
Anthony Taylor
Webmaster
http://buydentalequipment.com
Alright.. I had a peek inside and did what I can to bring EP into shape with regards to Google.Quote:
Originally Posted by llynix
This is untested and may contain bugs!! However the old version was broken so maybe this is better.
Here is the diff:
There are a few spots where it could be cleaner. And right now it just defaults to 'new' for the condition which seems to be required.Code:557c557
< 'v_froogle_ shipping' => $iii++,
---
> // 'v_froogle_ shipping' => $iii++,
559c559
< 'v_froogle_ upc' => $iii++,
---
> // 'v_froogle_ upc' => $iii++,
564c564
< 'v_froogle_manufacturer_id' => $iii++,
---
> // 'v_froogle_manufacturer_id' => $iii++,
566c566
< 'v_froogle_product_type' => $iii++,
---
> // 'v_froogle_product_type' => $iii++,
568c568
< 'v_froogle_currency' => $iii++,
---
> // 'v_froogle_currency' => $iii++,
572,573c572,573
< 'product_url' => $iii++,
< 'name' => $iii++,
---
> 'link' => $iii++,
> 'title' => $iii++,
576,580c576,580
< 'image_url' => $iii++,
< 'category' => $iii++,
< 'offer_id' => $iii++,
< 'instock' => $iii++,
< 'shipping' => $iii++,
---
> 'image_link' => $iii++,
> 'product_type' => $iii++,
> 'id' => $iii++,
> 'condition' => $iii++,
> // 'shipping' => $iii++,
582c582
< 'upc' => $iii++,
---
> // 'upc' => $iii++,
587c587
< 'manufacturer_id' => $iii++,
---
> // 'manufacturer_id' => $iii++,
589c589
< 'product_type' => $iii++,
---
> // 'product_old' => $iii++,
591c591
< 'currency' => $iii++,
---
> // 'currency' => $iii++,
754,756c754,756
< $row['v_froogle_instock'] = 'Y';
< $row['v_froogle_shipping'] = '';
< $row['v_froogle_upc'] = '';
---
> $row['v_froogle_instock'] = 'new';
> // $row['v_froogle_shipping'] = '';
> // $row['v_froogle_upc'] = '';
760c760
< $row['v_froogle_manufacturer_id'] = '';
---
> // $row['v_froogle_manufacturer_id'] = '';
762c762
< $row['v_froogle_product_type'] = 'OTHER';
---
> // $row['v_froogle_product_type'] = 'OTHER';
764c764
< $row['v_froogle_currency'] = 'usd';
---
> // $row['v_froogle_currency'] = 'usd';
798a799
> // Google merchants doesn't seem to require the quotes anymore A.T.
800,801c801,802
< $row['v_froogle_products_name_' . $lid] = '"' . html_entity_decode(strip_tags(str_replace('"','""',$row2['products_name']))) . '"';
< $row['v_froogle_products_description_' . $lid] = '"' . html_entity_decode(strip_tags(str_replace('"','""',$row2['products_description']))) . '"';
---
> $row['v_froogle_products_name_' . $lid] = html_entity_decode(strip_tags(str_replace('"','""',$row2['products_name'])));
> $row['v_froogle_products_description_' . $lid] = html_entity_decode(strip_tags(str_replace('"','""',$row2['products_description'])));
I went off the directions located here: http://www.google.com/support/mercha...&answer=160083
I've yet to test this, because I'm running it on a beta site which has a few mangled product prices that I don't want released in the wild. I'll get back with you guys when I've tested.
Anthony Taylor
Webmaster
http://buydentalequipment.com
llynix My advice would just use 'Google Base Feeder' as in the add-ons. This is a much better mod now than EP for google feeds as you can automate via con jobs. As everthing in software, this mod has not been develop lately and things have moved on...
Except the Google base feeder hardcodes the condition field. My Zen Cart installation has been hacked to add an additional condition field. So no matter what I would have to hack something. Since we'll be using Easy Populate in other projects it seemed the lesser of two evils. It wasn't too hard to hack into shape. Things haven't changed that much.Quote:
Originally Posted by Scrat
Anthony Taylor
Webmaster
http://buydentalequipment.com
Well - this week I took delivery of my shiny new HP Pavillion, loaded up with all the latest MS horror stories (vista64, MS Office 2007...)
... and I set about working with some clients' sites using EasyPop to manage some price changes.
Export TXT file to Temp Folder (All OK)
Open MS Excel 2007 (All OK)
Import TXT file into Excel (sort of OK, but apply all the format stripping procedures and it should be fine)
Do edits to data. (OK)
SAVE AS tab-delimited file (OK)
Open file in notepad++ to see if I can spot obvious MS junk (OK)
FTP to temp folder (OK)
Use EP to import into database...
... BANG! CRASH! SPLINTER... :shocking::shocking::shocking:
All product data disappears!
Major panic. Swallow heart pills. Take 2 cups of espresso.
-------------------------------------------
Go onto old computer.
Use similar process as above... THIS TIME use OPEN-OFFICE CALC instead of MS...
Runs as smooth as a Cheetah... :smile:
Data back in dbase - all is OK
What's the moral of the story? (You tell me...)
Hiya Schoolboy!
So... You DID make a backup before using EP??? LOL!
What you describe sure sounds like some funky end-of-line issues. Did they change something in excell 2007?
If you track it down, please post your discovery. I have had similar problems via excell on the MAC that necessitated using OO to export my tab or CSV files.
-cj