Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

most likely php5, search for the php fix for it

 

Yeah :)

But when I tries to add a product via EP, only the first row is being added.

You have any clue?

 

Cheers

Link to comment
Share on other sites

hi,

question about the way easypopulate imports a spreadsheet.

 

does it matter in what order the headers are set ?

 

like v_model first,v_products_id second,v_product_name third , and so on and so on.....

from what i have read in previous posts i know model# has to be first...but as for others i dont know if it matters to much....

can someone enlighten me please.

Puff

Link to comment
Share on other sites

I have looked thru quite a few pages in search for the problem I am having. I have too many products to "Download complete tab delimited..." Whats the fix? I also cannot find the php.ini file anywhere on my server... Please help

Link to comment
Share on other sites

Hi quys, I need your help.

I was searching on this forum for two hours, and without result.

PROBLEM:

I have EP2.78.

When uploading in column v_products_description_4 I use html code:

text here text here <p><img src="images/google-2-W-big.jpg"><br>

and after uploading on server are double quotes changed to this:

&%22images/google-2-W-big.jpg&%22

and image is not viewed.

 

So I am not able to add there other images and I need it.

 

Could you somebody help me?

Thank you very much.

Link to comment
Share on other sites

try with backslashes

 

\"images/google-2-W-big.jpg\"

 

 

 

Hi quys, I need your help.

I was searching on this forum for two hours, and without result.

PROBLEM:

I have EP2.78.

When uploading in column v_products_description_4 I use html code:

text here text here <p><img src="images/google-2-W-big.jpg"><br>

and after uploading on server are double quotes changed to this:

&%22images/google-2-W-big.jpg&%22

and image is not viewed.

 

So I am not able to add there other images and I need it.

 

Could you somebody help me?

Thank you very much.

Link to comment
Share on other sites

so again. I edit some code in product description field in admin and after downloadint through EP I'll get this characters & 34 instead of img src="images\..... (img src=& 34images\)

 

How it is possible? Why it do this?

 

SOLUTION:

make code this way:

<img src=images/google-2-W-big.jpg>

- without double qoutes.

I'm lama OMG.

Link to comment
Share on other sites

A recent text file will not import. The error is as follows:

 

| AE-91241 | small_imag | medium_ima | big_images | Aerotech R | Aerotech R | | 47.96 | 11.99 | 20 | 59.95 | 0.11 | 0000-00-00 | 0000-00-00 | 0 | 3 | 6 | 40 | Aerotech H | Model Rock | Aerotech R | Aerotech H | Taxable Go | Active Updated

| RT-29100C | small_imag | medium_ima | big_images | Rouse-Tech | Rouse-Tech | | 18.86 | 4.79 | 10 | 20.95 | 1 | 0000-00-00 | 0000-00-00 | 1 | 1 | 1 | 42 | Rouse-Tech | Model Rock | Rouse-Tech | | Taxable Go | Active !New Product!

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 '', '43')' at line 37

 

INSERT INTO products ( products_image, products_mediumimage, products_largeimage, products_model, products_price, products_discount, products_percent, products_retail, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, products_reorder, products_reorder_to, manufacturers_discount, manufacturers_id) VALUES ( 'small_images/small_rouse-tech.jpg','medium_images/medium_rouse-tech.jpg', 'big_images/big_rouse-tech.jpg','RT-29100C', '18.86', '4.79', '10', '20.95', '1', CURRENT_TIMESTAMP, "0000-00-00 00:00:00", "0000-00-00 00:00:00", '1', '1', '1', '1', '42', 1', '43')

 

[TEP STOP]

 

 

When I change the model number to be the same as the the first line on all the products, all of them will import as the single model number successfully. This proves there is nothing wrong with the file in general.

 

I then changed the second model number to RT-29100C or any other model number and the error repeats.

 

To me it looks as if there is some limit on the number of products that can be imported into the SQL. The text file only has 37 more products in it, but the current store has about 1000 products in it.

 

I tried the PHP 5 fix with no success. Help!

Link to comment
Share on other sites

try with backslashes

 

\"images/google-2-W-big.jpg\"

 

 

As I said - I was searching this forum - I saw this solution but it doesn't work.

I am not experienced coder - i know only html from school but with backslashes it really does'nt work.

Maybe something interesting for you - programmers.

Maybe has influence that i am running it under Czech (windows 1250) and some ISO characters coding.

Link to comment
Share on other sites

For multilangual categories in the shop

I solved my problem for multilingual shop. :D

 

The fields for categories have to llok like that:

 

v_categories_name_1_language_1 (for english in my case)

v_categories_name_1_language_4 (for french in my case)

 

instead of a simple:

 

v_categories_name_1

 

i im french i try to use EP for a english, french, and dutch shop

i tried your code , but when i import into ep carfelly putting the EOR at the end, it dosn't enter any description in the shop, only the product

any help ?

MS2

Link to comment
Share on other sites

Quote from 1readmeFIRST.txt from package

 

"

9. Run update.sql against your mysql database. Once the database is updated, you can set the configuration variables in the admin side under Configuration->Easy Populate. It is here where you adjust EP's operation for your store. I meant what I said, Please, Pretty please, do read the entire configuration stuff. Really. You'll be glad you did. You'll find all kinds of neat configurable stuff there. The instructions for using the various image mods and other supported contribtion variables are in there."

 

How do i go about doing this please? Complete newbie here so please be gentle with me ;-)

Link to comment
Share on other sites

phpmyadmin is great tool for online mysql database administration. Check with your host to see if it is not already installed..

 

i am hosting myself and i do have phpadmin installed. But what is the database file i need to run that file on and how i do that please?

Link to comment
Share on other sites

One more question

 

If i use this contribution to add products to oscommerce and then after some time i update the same products .. such as add an image or something or modify the record, will easy populate update the records for that product or will it just add the whole product again?

Link to comment
Share on other sites

hi,

i installed 2.78 now and i can download from admin panel

(complete) (model & catagorie)

 

if i try to download (Model/Price/Quantity) or (Model/Attributes) i get the following report:

1146 - Table 'db60053_9.TABLE_PRODUCTS_GROUPS' doesn't exist

SELECT customers_group_price, customers_group_id FROM TABLE_PRODUCTS_GROUPS WHERE products_id = 29 ORDER BY customers_group_id

[TEP STOP]

 

if i try to upload a file nothing happens, goes straight back to admin without doing anything and no report - just shown the Filiname.

 

if i open the downloaded fil in openOffice it opens in Writer/Web without any tables.

 

i don't understand how to deal with that file and how it can safe time???? - PLEASE HELP - NEED TO UPLOAD THOUSANDS OF PRODUCTS!!

 

here's a part what's in the downloaded file:

v_products_model v_products_image v_products_name_2 v_products_description_2 v_products_url_2 v_products_name_4 v_products_description_4 v_products_url_4 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_attribute_options_id_1 v_attribute_options_name_1_2 v_attribute_options_name_1_4 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_2 v_attribute_values_name_1_1_4 v_attribute_values_id_1_2 v_attribute_values_price_1_2 v_attribute_values_name_1_2_2 v_attribute_values_name_1_2_4 v_attribute_values_id_1_3 v_attribute_values_price_1_3 v_attribute_values_name_1_3_2 v_attribute_values_name_1_3_4 v_attribute_values_id_1_4 v_attribute_values_price_1_4 v_attribute_values_name_1_4_2 v_attribute_values_name_1_4_4 v_attribute_values_id_1_5 v_attribute_values_price_1_5 v_attribute_values_name_1_5_2 v_attribute_values_name_1_5_4 v_attribute_values_id_1_6 v_attribute_values_price_1_6 v_attribute_values_name_1_6_2 v_attribute_values_name_1_6_4 v_attribute_options_id_2 v_attribute_options_name_2_2 v_attribute_options_name_2_4 v_attribute_values_id_2_1 v_attribute_values_price_2_1 v_attribute_values_name_2_1_2 v_attribute_values_name_2_1_4 v_attribute_values_id_2_2 v_attribute_values_price_2_2 v_attribute_values_name_2_2_2 v_attribute_values_name_2_2_4 v_attribute_options_id_3 v_attribute_options_name_3_2 v_attribute_options_name_3_4 v_attribute_values_id_3_1 v_attribute_values_price_3_1 v_attribute_values_name_3_1_2 v_attribute_values_name_3_1_4 v_attribute_values_id_3_2 v_attribute_values_price_3_2 v_attribute_values_name_3_2_2 v_attribute_values_name_3_2_4 v_attribute_values_id_3_3 v_attribute_values_price_3_3 v_attribute_values_name_3_3_2 v_attribute_values_name_3_3_4 v_attribute_values_id_3_4 v_attribute_values_price_3_4 v_attribute_values_name_3_4_2 v_attribute_values_name_3_4_4 v_attribute_values_id_3_5 v_attribute_values_price_3_5 v_attribute_values_name_3_5_2 v_attribute_values_name_3_5_4 v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_tax_class_title v_status EOREOR 15-7001 art_widebandcommander.jpg Widebandcommander - schwarz widebandcommander www.widebandcommander.de Widebandcommander - schwarz widebandcommander www.widebandcommander.de 479 0.00 2006-01-10 15:48:50 10000 6 Farbe color 1 schwarz black 2 rot red 3 gr?n green 4 blau blue 5 orange orange 6 gelb yellow 7 Vorderrad front tyre 12 120/16,5 120/16,5 13 120/17 120/17 8 Hinterrad rear tyre 7 180/16,5 180/16,5 8 190/16,5 190/16,5 9 160/17 160/17 10 180/17 180/17 11 190/17 190/17 - Dynojet - WideBandCommander Taxable Goods Active EOREOR 15-7002 art_widebandcommander.jpg Widebandcommander - wei widebandcommander www.widebandcommander.de Widebandcommander - wei widebandcommander www.widebandcommander.de 479 0.00 2006-01-12 10:14:56 10000 6 Farbe color 1 schwarz black 2 rot red 3 gr?n green 4 blau blue 5 orange orange 6 gelb yellow 7 Vorderrad front tyre 12 120/16,5 120/16,5 13 120/17 120/17 8 Hinterrad rear tyre 7 180/16,5 180/16,5 8 190/16,5 190/16,5 9 160/17 160/17 10 180/17 180/17 11 190/17 190/17 - Dynojet - WideBandCommander Taxable Goods Active EOREOR 902-411 art_pc3usb.jpg Aprilia RSV Mille SP 00-01 - PC3 USB 903-411 
Der Powercommander IIIusb f?r bietet viele Moeglichkeiten zur Abstimmung 
freies Programmieren der Map fuer die Einspritzmenge
programmieren einer Map fuer jeden einzelnen Zylinder 
automatische Programmierung ?ber die TuningLink-Software bei autorisierten Tuning-Centern moeglich 
Verwendung einer virtuellen Beschleunigerpumpe (Acceleration Pump Feature) 
zusaetzlich koennen Dynojet-Zubehoerteile wie Schaltunterbrechung oder Zuendverstellung angeschlossen werden 
Im Lieferumfang enthalten sind neben dem Powercommander mit zum Serienkabelbaum passenden Steckern alle benoetigten Befestigungsteile, ein USB-Schnittstellenkabel und eine Software-CD. Eine Standardmap ist bereits geladen. 
www.powercommander.com Aprilia RSV Mille SP 00-01 - PC3 USB 903-411 
Dynojet recommends use of Power Commander on all fuel-injected motorcycles 
Allows fine-tuning of your fuel-injected when changing air cleaner pipes and cams 
Each Power Commander unit comes with a built in microprocessor and Is supplied with a specific map designed to improve performance over stock 
A software package and computer link cable which allows you to fully map the fuel and Ignition curve is also included 
Dynojet Is continuously mapping different combinations for each bike special maps can be downloaded at Dynojet's web site (www.powercommander.com) 
www.powercommander.com 329 0.00 2006-01-12 16:30:52 10000 6 Farbe color 1 schwarz black 2 rot red 3 gr?n green 4 blau blue 5 orange orange 6 gelb yellow 7 Vorderrad front tyre 12 120/16,5 120/16,5 13 120/17 120/17 8 Hinterrad rear tyre 7 180/16,5 180/16,5 8 190/16,5 190/16,5 9 160/17 160/17 10 180/17 180/17 11 190/17 190/17 - Dynojet - Powercommander Aprilia Taxable Goods Active EOREOR 902-411 art_pc3usb.jpg Aprilia RSV Mille 01-03 - PC3 USB 902-411 
Der Powercommander IIIusb f?r bietet viele Moeglichkeiten zur Abstimmung 
freies Programmieren der Map fuer die Einspritzmenge
programmieren einer Map fuer jeden einzelnen Zylinder 
automatische Programmierung ?ber die TuningLink-Software bei autorisierten Tuning-Centern moeglich 
Verwendung einer virtuellen Beschleunigerpumpe (Acceleration Pump Feature) 
zusaetzlich koennen Dynojet-Zubehoerteile wie Schaltunterbrechung oder Zuendverstellung angeschlossen werden 
Im Lieferumfang enthalten sind neben dem Powercommander mit zum Serienkabelbaum passenden Steckern alle benoetigten Befestigungsteile, ein USB-Schnittstellenkabel und eine Software-CD. Eine Standardmap ist bereits geladen. 
www.powercommander.com Aprilia RSV Mille 01-03 - PC3 USB 902-411 
Dynojet recommends use of Power Commander on all fuel-injected motorcycles 
Allows fine-tuning of your fuel-injected when changing air cleaner pipes and cams 
Each Power Commander unit comes with a built in microprocessor and Is supplied with a specific map designed to improve performance over stock 
A software package and computer link cable which allows you to fully map the fuel and Ignition curve is also included 
Dynojet Is continuously mapping different combinations for each bike special maps can be downloaded at Dynojet's web site (www.powercommander.com) 
www.powercommander.com 329 0.00 2006-01-12 10:53:28 10000 6 Farbe color 1 schwarz black 2 rot red 3 gr?n green 4 blau blue 5 orange orange 6 gelb yellow 7 Vorderrad front tyre 12 120/16,5 120/16,5 13 120/17 120/17 8 Hinterrad rear tyre 7 180/16,5 180/16,5 8 190/16,5 190/16,5 9 160/17 160/17 10 180/17 180/17 11 190/17 190/17 - Dynojet - Powercommander Aprilia Taxable Goods Active EOREOR.............................

Link to comment
Share on other sites

i have lots of products with the same product number (wich is product_model??) and different titles even in the same categories..

 

does ist work like this? or do i need my own product number for each article?

Link to comment
Share on other sites

i have lots of products with the same product number (wich is product_model??) and different titles even in the same categories..

 

does ist work like this? or do i need my own product number for each article?

 

DONE!

 

i've changed all my product_model

Link to comment
Share on other sites

I had the same. I solved it this way.

 

Change 'If .....accordingly. ', 17, 1 etc into "If ...... accordingly ", 17 etc.

So make the quotes dubble quotes and erase the dot.

 

Gauthier

 

 

hi,

 

I just downloaded EasyPopulate 2.79 and tried to upload the SQL-Statements:

 

Following Error appears!

 

INSERT INTO configuration

VALUES (

 

'', 'Temp Directory', 'EP_TEMP_DIR', 'temp/', 'If you changed your directory structure from stock and do not have /catalog/temp/, then you'll need

TO CHANGE this accordingly. ', 17, 1, now(), now(), NULL, NULL); INSERT INTO configuration VALUES ('', '

SET TimeLimt ', 'EP_SET_TIME_LIMIT ', 'false ', ' SET TO "true" IF you are NOT ON a safe MODE server AND you are getting timeouts. ', 17, 2, now(), now(), NULL, 'tep_cfg_select_option(

array(

\ 'true\', \'false\'),'

)

 

:(

Link to comment
Share on other sites

I installed EP 2-79. I have a problem I can not solve with attached manuals.

I look around in this forum but could not find the solution.

 

After an attempt to import an file I got the following message

 

..........................: | Download: | Download: | Download: | 13 | | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | Hardware | Mice | | | | | | | | | | | | | | Taxable Go | EP_STATUS_ Updated

1064 - You have an error in your SQL syntax near '0,0, CURRENT_TIMESTAMP ,CURRENT_TIMESTAMP)' at line 1

 

INSERT INTO categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified ) VALUES (21,,0,0, CURRENT_TIMESTAMP ,CURRENT_TIMESTAMP)

 

[TEP STOP]

 

What did I do:

- exported the default database from OScommerce to a txt file (via the EP admin tool)

- I opened it in Excell and saved it again;

- imported the file via EP in OScommerce. NO PROBLEM

 

2nd test with a new product in an existing catagory gave no problems too.

 

BUT if I give that new product a new category name 1 and category name 2 I get the message as stated above.

I think no new categories can be generated by EP. And for what I read the application EP should do that automatically.

 

Who can help me with.

 

thanks in advance

Gauthier

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...