Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

I need some help from somebody familiar with Easy Populate out there.

 

If i UPDATE my products with EP, it loads and updates OK, shows product updated.

 

However, now my products show up in 2 or 3 other categories that they do not belong in! GPS products in with kitcenware...

 

It happens even when I update with the same .txt file that they were loaded with. The only way I do not get wierd categories is if I wipe out all products and categories and load from scratch. I sure don't want to have to do that every time I need to update.

 

Any ideas?

 

Chris Colman :'(

Share this post


Link to post
Share on other sites
It is probably because the EP uses extra image fields that you don;t have installed.

you need to comment these fields in the EP file to make them inactive.

 

 

Pixc - How do you edit out all of this information? I am getting a very similar error when I goto download the ep complete file. I am getting

 

1054 - Unknown column 'p.products_price1_qty' in 'field list'

 

SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

 

 

i thought that i had found all the areas to edit everything out, but i guess I was wrong.

 

any and all help you can provide is appreciated.

 

Thank you in advance

Share this post


Link to post
Share on other sites
Pixc - How do you edit out all of this information? I am getting a very similar error when I goto download the ep complete file. I am getting

 

1054 - Unknown column 'p.products_price1_qty' in 'field list'

 

SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

i thought that i had found all the areas to edit everything out, but i guess I was wrong.

 

any and all help you can provide is appreciated.

 

Thank you in advance

 

search for the code you just pasted in your previous post in your EP file, and remove

 

 p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks,

 

if you don't use quantity price breaks in your store

 

look carefully in your file for every occurence of this and take it out

Share this post


Link to post
Share on other sites
search for the code you just pasted in your previous post in your EP file, and remove

 

 p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks,

 

if you don't use quantity price breaks in your store

 

look carefully in your file for every occurence of this and take it out

 

Perfect!!! THANK YOU FOR YOUR HELP!!! I got it to Upload and Download properly doing just what you said.

 

One more question, and everything will be 100%.

 

I am creating a site for printer cartridges. one of the extra fields that i have is printer compatibility.

 

Right now the way it shows up is.

 

 

Printer Compatibility: Printer 1, Printer 2, Printer 3, ........

 

Is there a way for me to make it show up

 

Printer Compatibility: Printer 1

Printer 2

Printer 3

.....

 

I know that this is not part of easy populate... but i saw you were active in the new fields forum too.

 

THank you again

Share this post


Link to post
Share on other sites
creating a site for printer cartridges. one of the extra fields that i have is printer compatibility.

 

Right now the way it shows up is.

Printer Compatibility: Printer 1, Printer 2, Printer 3, ........

 

Is there a way for me to make it show up

 

Printer Compatibility: Printer 1

Printer 2

Printer 3

.....

 

just enter some basic HTML in your extra field when you enter your data in it

 

<b>Printer Compatibility</b>:
<ul>
<li>Printer 1
<li>Printer 2
<li>Printer 3
</ul>

 

and that will do the trick :-)

Edited by pixclinic

Share this post


Link to post
Share on other sites
just enter some basic HTML in your extra field when you enter your data in it

 

<b>Printer Compatibility</b>:
<ul>
<li>Printer 1
<li>Printer 2
<li>Printer 3
</ul>

 

and that will do the trick :-)

 

 

ok..... I will try that on the next upload.... one more thing that I just noticed.... Is there a way for me to set in easypopulate defaul category images?

 

In the older version, i used to be able to control a default picture if i did not have one, and also a default image for the categories as well.

 

Is there a way to do the same now? I trying going into mySQL, and defaulting the category image field to heading.gif

 

Thank you again for your help

Share this post


Link to post
Share on other sites

Hello,

 

I am using this contribution and it is working great.

I just have one question I was wondering if anyone could help.

I have an extra field for my products (this is not through the products extra field contribution) it is the Display MSRP & Savings contribution. This contribution has added an extra field to my product which is nice and useful. Now what I'm looking for is to be able to download this field using the EasyPopulate and also upload/update the information.

 

Any suggestion will be much appreciated.

 

 

Thanks again.


Regards,

Share this post


Link to post
Share on other sites
Hello,

 

I am using this contribution and it is working great.

I just have one question I was wondering if anyone could help.

I have an extra field for my products (this is not through the products extra field contribution) it is the Display MSRP & Savings contribution. This contribution has added an extra field to my product which is nice and useful. Now what I'm looking for is to be able to download this field using the EasyPopulate and also upload/update the information.

 

Any suggestion will be much appreciated.

Thanks again.

 

if this field is added to your "products" table, it's pretty easy to add it to your easypopulate:

locate the exact name of field and add it everywhere in easypopulate by cloning a field like "product_name": do a complete search in the file and insert your field name next to it. It takes some time, but can be painless if you have a good HTML editor

Share this post


Link to post
Share on other sites
if this field is added to your "products" table, it's pretty easy to add it to your easypopulate: ...

 

pixclinic,

Thank you for your quick reply.

Yes, the field is in products table and it is called "products_msrp". But I'm not sure how to update my easypopulate page.

Here is my easypopulate page.

Edited by omidhz

Regards,

Share this post


Link to post
Share on other sites
pixclinic,

Thank you for your quick reply.

Yes, the field is in products table and it is called "products_msrp". But I'm not sure how to update my easypopulate page.

Here is my easypopulate page.

The link didn't show up. Here it is again.

My easypopulate file.


Regards,

Share this post


Link to post
Share on other sites
pixclinic,

Thank you for your quick reply.

Yes, the field is in products table and it is called "products_msrp". But I'm not sure how to update my easypopulate page.

Here is my easypopulate page.

 

It's not difficult, you just have to clone a field like product_name, or product ID in your EP file.

Doesn't require programming skills, just common sense.. and some time.

Share this post


Link to post
Share on other sites

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/fhlinux184/p/************.co.uk/user/htdocs/admin/easypopulate.php:1) in /home/fhlinux184/p/************.co.uk/user/htdocs/admin/includes/functions/sessions.php on line 68

 

 

Hi,

 

Can anyone tell me what this means?

 

Regards

 

Steve


Regards

 

Steve

Share this post


Link to post
Share on other sites

is there a way to set a default category pic in easy populate? the way it is now, pics do not load for the category, and i have to go into the admin and add them in manually.

 

Is there a default setting that I can do in either easypopulate.php, or in the actual EP file???

Share this post


Link to post
Share on other sites
is there a way to set a default category pic in easy populate? the way it is now, pics do not load for the category, and i have to go into the admin and add them in manually.

 

Is there a default setting that I can do in either easypopulate.php, or in the actual EP file???

 

Tell me if it's a stupid idea, but why don't you try to your MyPhp admin and replace the NULL default value of the categories_image field from the categories table by a "defaultimage.jpg" (without the quotes). Load defaultimage.jpg in your image directory and see what happens when you create a new category. Every new category created (even in admin mode, not only EP will then have this default image until you replace it)

Edited by pixclinic

Share this post


Link to post
Share on other sites
Tell me if it's a stupid idea, but why don't you try to your MyPhp admin and replace the NULL default value of the categories_image field from the categories table by a "defaultimage.jpg" (without the quotes). Load defaultimage.jpg in your image directory and see what happens when you create a new category. Every new category created (even in admin mode, not only EP will then have this default image until you replace it)

i actually tried that (even though i am scared of that area), before i posted, and it is still not working.... the old easypopulate files used to be able to have a defaulted category image.... and product image too....

 

i just didnt know if this was still possible.

Share this post


Link to post
Share on other sites
i actually tried that (even though i am scared of that area), before i posted, and it is still not working.... the old easypopulate files used to be able to have a defaulted category image.... and product image too....

 

i just didnt know if this was still possible.

 

That's right: in my easypopulate 3.0, I found this:

 

// set them to your own default "We don't have any picture" gif
//$default_image_manufacturer = 'no_image_manufacturer.gif';
//$default_image_product = 'no_image_product.gif';
//$default_image_category = 'no_image_category.gif';

// or let them get set to nothing
$default_image_manufacturer = '';
$default_image_product = '';
$default_image_category = '';

 

but I don't see this capability in 2.8 or 2.9 for example...

Share this post


Link to post
Share on other sites

Hey guys

 

Im pretty new to all this stuff and have recently done a fresh install of OSC and have added this contribution. Everything seemed to work fine except after i have downloaded the .txt file and alter it in excel i recieve the following error.

 

Any help from anyone would be greatly appreciated

 

Im still working on the std database just until i get things running

 

Regards Thomas

 

Easy Populate 2.76c-MS2 - Default Language : English(1)

 

File uploaded.

Temporary filename: c:/wamp/tmp\php62.tmp

User filename: EP2006Oct10-1111.txt

Size: 81842

| MG200MMS | matrox/mg2 | Matrox G20 | Reinforcin | www.matrox | Matrox G20 | Unterst?tz | www.matrox | Matrox G20 | Reinforcin | www.matrox | 320.99 | 23 | 0000-00-00 | 10/10/2006 | 32 | 1 | Color | Farbe | Color | 2 | Size | Gr??e | Talla | 3 | Model | Modell | Modelo | 5 | Value | Value Ausg | Value | 0 | 6 | Premium | Premium Au | Premium | 100 | 7 | Deluxe | Deluxe Aus | Deluxe | | 8 | PS/2 | PS/2 Ansch | PS/2 | | 9 | USB | USB Anschl | USB | | 4 | Memory | Speicher | Memoria | 1 | 4 mb | 4 MB | 4 mb | 0 | 2 | 8 mb | 8 MB | 8 mb | 50 | 3 | 16 mb | 16 MB | 16 mb | 70 | 4 | 32 mb | 32 MB | 32 mb | | 5 | Version | Version | Version | 10 | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | | Matrox | Hardware | Graphics C | | Taxable Go | Active Updated

| MG400-32MB | matrox/mg4 | Matrox G40 | Dramatical | www.matrox | Matrox G40 | Neu! Matro | www.matrox | Matrox G40 | Dramatical | www.matrox | 534.99 | 23 | 0000-00-00 | 10/10/2006 | 32 | 1 | Color | Farbe | Color | 2 | Size | Gr??e | Talla | 3 | Model | Modell | Modelo | 5 | Value | Value Ausg | Value | | 6 | Premium | Premium Au | Premium | 0 | 7 | Deluxe | Deluxe Aus | Deluxe | 120 | 8 | PS/2 | PS/2 Ansch | PS/2 | | 9 | USB | USB Anschl | USB | | 4 | Memory | Speicher | Memoria | 1 | 4 mb | 4 MB | 4 mb | | 2 | 8 mb | 8 MB | 8 mb | | 3 | 16 mb | 16 MB | 16 mb | -10 | 4 | 32 mb | 32 MB | 32 mb | 0 | 5 | Version | Version | Version | 10 | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | | Matrox | Hardware | Graphics C | | Taxable Go | Active Updated

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's fastest graphics chip, the Millennium G400 Series takes explosive acceleration' at line 3

 

UPDATE products_description SET products_name='Matrox G400 32MB', products_description='Dramatically Different High Performance Graphics

 

Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry's fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC's arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer.

 

Key features:

 

* New Matrox G400 256-bit DualBus graphics chip

* Explosive 3D, 2D and DVD performance

* DualHead Display

* Superior DVD and TV output

* 3D Environment-Mapped Bump Mapping

* Vibrant Color Quality rendering

* UltraSharp DAC of up to 360 MHz

* 3D Rendering Array Processor

* Support for 16 or 32 MB of memory

 

', products_url='www.matrox.com/mga/products/mill_g400/home.htm' WHERE products_id = '2' AND language_id = '1'

 

[TEP STOP]

Share this post


Link to post
Share on other sites

As this is a looong thread and right now i have limited time, allow me to ask you guys: what is the last good version of this contrib?

 

Thanks in advance.


Sorry for my bad english language!

Share this post


Link to post
Share on other sites
As this is a looong thread and right now i have limited time, allow me to ask you guys: what is the last good version of this contrib?

 

Thanks in advance.

 

This thread is very long because this question has been asked 200 times in it ;)

 

There is no "good version" but "a version that is right for you"

 

I use several versions and depending on the MODs I have on them, I chose between 2.7 and 3.0

provide a list of your MODs we might be able to able you to choose

Edited by pixclinic

Share this post


Link to post
Share on other sites
This thread is very long because this question has been asked 200 times in it ;)

 

There is no "good version" but "a version that is right for you"

 

I use several versions and depending on the MODs I have on them, I chose between 2.7 and 3.0

provide a list of your MODs we might be able to able you to choose

 

 

Ok, I get it.

 

I have the following mods:

 

- customers_extra_fields

- extra_images_with_admin1_3

- EZ_Price_Updater

- Fixed Width Site With CSS

- Order_IP_Recorder_1.4 addon

- best_sellers_rolling_1

- dynamic_sitemap v 2.0

- Java Categories

- New Products Changing

- osC-Cache_v1.1a

- Purchase Without Account_0.910

- Switch between Displaying Prices Inc_Ex VAT.

 

Hope this helps.


Sorry for my bad english language!

Share this post


Link to post
Share on other sites
- extra_images_with_admin1_3

 

 

Hope this helps.

 

this mod adds extra images to the product in a separate table, thus making very difficult to have EP managing this if you are not an expert programmer. I would say if you can live without the extra images being managed, you may work with a 2.8 or 2.9

 

If you want your extra images working with EP, 2 options:

1) you hore a php expert programmer (and he/she will need to be an Oscommerce expert too, don;t know if if worth the price you will have to pay)

2) you uninstall the extra_images_with_admin1_3 MOD and replace it by a mod that intergrates the images in the "products" table, not in a separate table

 

like mopics: http://www.oscommerce.com/community/contributions,1611/

 

and use an easy populate version that handles these extra image fields (called v_products_subimage1,v_products_subimage2 etc...) or something similar. I have a version 2.8 opened in front of me now, and it has them

 

Hope this helps

Share this post


Link to post
Share on other sites

Well, I hope it helps too, as I'll uninstall Extra Images right now and see how it's going.


Sorry for my bad english language!

Share this post


Link to post
Share on other sites

Can you give me a link to a good 2.8 or 2.9 version? I see there are more than one of each version and I don't know wich one to choose. Thanks. ;)


Sorry for my bad english language!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×