8796 replies to this topic

[Mibble]

you cant use ep for displaying one product but it is meant for two, you will need to use attributes.
unless someone knows another way . .

[ricky75]

dinh, on Jan 10 2005, 06:27 AM, said:

IT WORKED!!!

THANK YOU SO MUCH.

I have been checking this thread for updates the past few weeks trying to solve this problem. 

<{POST_SNAPBACK}>

For me, it still doesn't work.

I stil get this massage:
File uploaded.
Temporary filename: c:/temp\php7D1A.tmp
User filename: aanbiedingen.txt
Size: 10658

But no products import.

Does anybody knows an fix.

Ricky

[babyhopper]

I'm having issues with my image sizes.
using EP STS and osC2.2

Here are my image properties:

Small Image Width 	 100    
Small Image Height 	 Info 
Heading Image Width  60  Info 
Heading Image Height 	 Info 
Subcategory Image Width  57  Info 
Subcategory Image Height 	 Info 
Calculate Image Size  true  Info 
Image Required  false  Info

The problem is that my images are the same small size where ever the products are displayed. If I set all the numbers to 0, then it displays the full size image. There doesn't seem to be any inbetween. No of the other numbers seem to do anything. Help

Thanks,
ZAch

[babyhopper]

Anyone at all have a solution?

[Mibble]

whether u r using easypopulate or adding the products manually you will get the same thing.
you need to add a thumbnailer contribution or have multiple size images (small and large) and use mopics, something like that.

[alfa]

its a new installetion of oscommerce-2.2ms2

I try to get easy populate to work

I download a file from the databas no problem.
I change price on one product.
upload the file he says

File uploaded.
Temporary filename: C:\WINDOWS\TEMP\php1C.tmp
User filename: EP2005Jan12-0012.txt
Size: 744

and there are No change in product price in the shop

Maby the wrong thing are
Temporary filename: C:\WINDOWS\TEMP\php1C.tmp

Please help me

Peter

[Mibble]

if you have access to c:\windows\temp then the directory needs to be at 777 permissions

[alfa]

What shold I do?
What changes and where.

Peter

[blucollarguy]

I am posting because I am not sure if this issue was specific to me(maybe I am using the wrong version or something) or not. I realized that my Froogle feed was sending ALL my prod to froogle wether the product was actually active or not. Nothing was telling Froogle about the quantity or availability. Froogle has a field for telling them about your stock. It is set in EP as a default to 'Y' which is in stock. I needed to tell Froogle if the product was not in stock. So this is what I did:
Find this:

// Other froogle defaults go here for now
  $row['v_froogle_instock'] 	 = 'Y';

And replace it with this:

// Other froogle defaults go here for now
                $row['v_froogle_instock']                 = 'Y'; // default is active
        if      ($row['v_products_quantity'] == 0) {
                // if zero qty products, tell Froogle
                $row['v_froogle_instock']                 = 'N';
        }
//   $row['v_froogle_instock']                 = 'Y';   Replaced this so Froogle does not
//  Think EVERY prod in the catalog is available, status setting was not being used

Backup first as I cannot completely guarantee that this will work for everyone. You may not even need this, but I did. Hope it helps someone. Craig

BTW If this issue is specific to me, then ignore me.

[alfa]

Nobody can help me
i cant get it to work.

its a new installetion of oscommerce-2.2ms2

I try to get easy populate to work

I download a file from the databas no problem.
I change price on one product.
upload the file he says

File uploaded.
Temporary filename: C:\WINDOWS\TEMP\php1C.tmp
User filename: EP2005Jan12-0012.txt
Size: 744

and there are No change in product price in the shop

Maby the wrong thing are
Temporary filename: C:\WINDOWS\TEMP\php1C.tmp

Please help me

Peter

[marcoren]

When people say "download file from database", are you exporting the database? How are you doing this, a mysql dump?

[marcoren]

I got easypopulate functioning but not working.

I'm getting this in my easypopulate, I assume it's an error with my data but I'm not sure what that is.

File uploaded.
Termporary filename: D:\WINDOWS\TEMP\php28.tmp
User filename: delimit.txt
Size: 324215
| ARCL97A | ARCL97A.gi | ARCL97A | Full Kit 1 | | | | | | | | 130 | 5 | | | | 1 | Color | Farbe | Color | 2 | Size | Größe | Talla | 3 | | | | 4 | | | | 5 | | | | Acura | CL | 1997 | | --none-- | Active Updated
| ACR-10A; | ARCL01A; | ARCL01B; | ARCL01C; | ARCL01D; | ARMX03A; | ARMX03B; | ARMX01A; | ARMX01B; | ARMX01C; | ARMX04A; | ARMX04B; | ARMX04C; | ARMX04D; | ARMX04E; | ARMX03OA | ARMX05A; | ARMX05B; | ARMX05C; | ARMX05D; | ARMX05E; | ACR-6A;A | ACR-1A;A | ACR-1C;A | ACR-1B;A | ACR-12A; | ACR-12B; | ACR-11A; | ACR-11B; | ARTL04C; | ARTL04D; | ARTL04N; | ARTL04A; | ARTL04B; | ARTL04M; | BMW-3A;B | BMW-3B;B | BMW-3C;B | BMW-S5-1 | BMW-2A;B | BMW-2B;B | X-BMW-1B | X-BMW-1A | BMW-X5-1



No errors yet I only get one entry into the database. A sample of my data is here:

v_products_model;v_products_image;v_products_name_1;v_products_description_1;v_p
roducts_url_1;v_products_name_2;v_products_description_2;v_products_url_2;v_produ
cts_name_3;v_products_description_3;v_products_url_3;v_products_price;v_products_
weight;v_date_avail;v_date_added;v_products_quantity;v_attribute_options_id_1;v_a
ttribute_options_name_1_1;v_attribute_options_name_1_2;v_attribute_options_name_1
_3;v_attribute_options_id_2;v_attribute_options_name_2_1;v_attribute_options_name
_2_2;v_attribute_options_name_2_3;v_attribute_options_id_3;v_attribute_options_na
me_3_1;v_attribute_options_name_3_2;v_attribute_options_name_3_3;v_attribute_opti
ons_id_4;v_attribute_options_name_4_1;v_attribute_options_name_4_2;v_attribute_op
tions_name_4_3;v_attribute_options_id_5;v_attribute_options_name_5_1;v_attribute_
options_name_5_2;v_attribute_options_name_5_3;v_manufacturers_name;v_categories_n
ame_1;v_categories_name_2;v_categories_name_3;v_tax_class_title;v_status;EOREOR
ARCL97A;ARCL97A.gif;ARCL97A;Full Kit 15 Pcs;;;;;;;;130 ;5;;;;1;Color;Farbe;Color;2;Size;Größe;Talla;3;;;;4;;;;5;;;;Acura ;CL;1997;;--none--;Active;EOREOR
ACR-10A;ACR-10A.gif;ACR-10A;Full Kit Match OEM 14 Pcs;;;;;;;;130 ;5;;;;1;Color;Farbe;Color;2;Size;Größe;Talla;3;;;;4;;;;5;;;;Acura ;CL;1998-2000;;--none--;Active;EOREOR


I don't have any spaces or data after EOREOR.

I look forward to your responses.

--Marc

[JimmyJam]

marcoren, on Jan 14 2005, 03:42 AM, said:

When people say "download file from database", are you exporting the database?  How are you doing this, a mysql dump?

<{POST_SNAPBACK}>

With the contribution EasyPopulate you can export the articles from the (relational) osCommerce database in a flat file (non-relational) form. This makes it easier to get to your list of articles.
Also, you can import articles into the osCommerce database from e.g. an Excel spreadsheet through a flat file.

[marcoren]

JimmyJam, on Jan 14 2005, 03:58 PM, said:

With the contribution EasyPopulate you can export the articles from the (relational) osCommerce database in a flat file (non-relational) form. This makes it easier to get to your list of articles.
Also, you can import articles into the osCommerce database from e.g. an Excel spreadsheet through a flat file.

<{POST_SNAPBACK}>

Thanx JimmyJam. I figured it out after the fact. That's how I followed up with the second post. Still having issues with data formatting(i think).

[Flip]

Why on a clean install of OSCommerce when I upload an EP file with some new field it's never shown in the right place?
And also why is it Inactive by default when I did the correction in the easypopulate file and its quantity is not zero?

[MikeMike]

Now I am also getting this error when trying to update my products with easypopulate

File uploaded. 
Temporary filename: /tmp/phpvv3aZ0
User filename: import.txt
Size: 43976

Nothing is getting updated...

I haven't changed anything at all in my files. Anyone know the reason for this.

Edited by MikeMike, 18 January 2005, 14:45.

[MikeMike]

MikeMike, on Jan 18 2005, 10:44 AM, said:

Now I am also getting this error when trying to update my products with easypopulate

File uploaded. 
Temporary filename: /tmp/phpvv3aZ0
User filename: import.txt
Size: 43976

Nothing is getting updated...

I haven't changed anything at all in my files. Anyone know the reason for this.

<{POST_SNAPBACK}>

Nevermind... I found an error in my txt file

[marcoren]

When using osCommerce, where is the association between category and product made by index.php?


I see the associations exist in the "categories_to_products" table after running the installation with osCommerce. However, osCommerce doesn't bring up the products after navigating through the categories.

[Salvo]

Hi all

I have just used the easypopulate and everything worked fine except that out of 400 products whici there are all active, only 91 showed but active and the rest inactive.

I tried a few times and every time I had the same amount active/inactive. Checked the file I am uploading and the all active expect 4

Why this pecularity?

Thanks

[Mibble]

did you read thru your easypopulate.php file and edit accordingly to active/inactive with stock?
do you have inventory counts in the items marked inactive?
those two things tie together. and the installation file explicitely states very strongly to get it working properly you need to read the file.