Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

I have installed the excellent Easy Populate module, and it is working perfectly for me.

I also have the Product Extra Field module, and this too is also working great.

 

However, my problem is when using both together.

 

I have used the contribution by geoffreywalton ( Product Extra Fields and 2.76f-MS2 r1 ) and have followed through the instructions about what to do and what I need to change in the admin/easypopulate.php file.

 

I download the Extra Fields .csv file to edit and make my changes, save it as a tab-delimited txt file and upload the file back. I see confirmation on the page saying ...

 

File uploaded.

Temporary filename: /tmp/phpYkbBcv

User filename: apd2.txt

Size: 1578

1 | | 80cm | UPDATE_EP

4 | | 80cm | UPDATE_EP

7 | | Pieces | UPDATE_EP

 

However, when I go to check my products, none of my changes are visable. It appears as though I can download, edit and then upload the file with no problems, but it seems that somewhere, the uploaded file is not updating the database. I have been looking at trying to fix this all morning, but seem to be getting nowhere.

 

Has anyone else had such a problem when using the Easy Populate and the Products Extra Fields contributions together ?? I have searched through the forums here, but haven't found any suggestion or solution as to what I can do to fix my specific problem.

 

Any help from anyone would really be most appreciated.

 

Thanks

 

Alex

Posted

Just wondering if anyone can help with this ??

 

Been trying various things all morning as well as all day yesterday and seem to be stuck in a loop.

 

Thanks

 

Alex

Posted

Did you look at the sample file in the documentation that shows what has to be in the "upload" file?

 

Then did you apply this knowledge to your particular extra products?

 

Should get an output like

 

KA-TI-H10 : KA-TI-H10 : 2411

1 | KA-TI-H10 | £529.00 | Product Updated

12UCM : 12UCM : 2412

1 | 12UCM | £79.00 | Product Updated

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted (edited)

I've also got a problem using EP with PEF, everything works good with the seperate contributions BUT when I try to populate the Extra Fields table it adds the fields into the table but sets the products_id to 0 (zero). It's driving me mad.

 

I've tried multiple versions of EP, adding the fixes, etc but it still keeps doing this.

 

Upload file is spot as I've double, triple checked it against the manual.

 

This is a biggie for me as all my products have 7 extra fields, eg, voltage, capacity, etc.

 

Any ideas would be most helpful?, I've searched and searched, my head is starting to hurt!!

Edited by tryer
Posted (edited)

Hi,

 

I am having trouble with this contribution, which btw I think is awesome. I installed it no problem and made the proper changes in easypopulate.php. I ran a test to see if it worked fine, so I downloaded a complete file, made a few changes and then uploaded it again. Everything seemed fine, but I noticed that some of my products were switched from the original category to another category, some of the pictures were also switched from the original product to another, and some of the products were added to a few new categories. If I try to delete the repeated products from my admin panel, they won't delete.

 

What did I do wrong? I am not sure why it would switch things around, if the excel file is accurate.

 

Any ideas? I'd love to be able to use this contribution, as it would save me tons of time. :D

 

Thanks,

 

Yol

Edited by jailaxmi

I repeat myself when under stress, I repeat myself when under stress, I repeat myself...

 

--King Crimson (“Discipline”)

Posted (edited)

I have just exported and imported the same file using Easy Populate 2.76f-MS2 r1

 

Works with and without fields being enclosed in quotes.

 

v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ

cts_extra_fields_value,EOREOR

"19LS4D","List Price","1","£219.00",EOREOR

"22LS4D","List Price","1","£259.00",EOREOR

"KDL20B4050U","List Price","1","£399.00",EOREOR

 

v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ

cts_extra_fields_value,EOREOR

KA-TI-H10,List Price,1,£529.00,EOREOR

12UCM,List Price,1,£79.00,EOREOR

17ARM,List Price,1,£99.00,EOREOR

 

John

 

Sample for you

 

v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ

cts_extra_fields_value,EOREOR

12UCM,Voltage,1,7.0,EOREOR

12UCM,Capacity,2,350ma,EOREOR

12UCM,List Price,3,£99.00,EOREOR

 

The products_extra_fields_id will vary according to the value of you ids.

 

Yol

 

Try reading the EP documentation that comes with the contribution and follow the instructions on how and more importantly in which thread to ask for help.

Edited by geoffreywalton

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted
Yol

 

Try reading the EP documentation that comes with the contribution and follow the instructions on how and more importantly in which thread to ask for help.

 

Oh, ok. Sorry about that. I just did a search and assumed this was the main thread. Will look it up. :blush:

 

Thanks,

 

Yol

I repeat myself when under stress, I repeat myself when under stress, I repeat myself...

 

--King Crimson (“Discipline”)

Posted

This is my input file, it imports the fields into the PFE table but sets the product id as 0 (zero) and obviously doesn't link it to the necessary product:

 

v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ

cts_extra_fields_value,EOREOR

134,Capacity,1,1100mAh,EOREOR

134,Voltage,2,9.6v,EOREOR

134,Dimensions,3,100mm x 100mm x 100mm,EOREOR

134,Battery Type,4,Li-ion,EOREOR

134,Weight,5,200 grams,EOREOR

134,Colour,6,Grey,EOREOR

134,Standard or High Capacity,7,Standard,EOREOR

 

 

Any ideas? Not being able to use this great contrib is going to cause me big headaches..!

Posted (edited)

What version of EP are you using?

 

Does a product with model no of 134 exist?

 

Have you looked in PEF to check no and descriptions are correct.

 

Is the model no in PTPEF zero?

 

How many records are created with this zeoro value?

Edited by geoffreywalton

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted

My EP version etc, is:

 

EP vers: 2.76g-MS2

osCommerce 2.2-MS2

OS: Linux 2.6.18-92.1.13.el5

HTTP: Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8b mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

DB: MySQL 5.0.51a-community-log

PHP: 5.2.6 (Zend: 2.2.0)

 

Extra Fields: true

 

Extra Fields table is:

 

products_extra_fields_id products_extra_fields_name products_extra_fields_order products_extra_fields_status languages_id

1 Capacity 3 1 1

2 Voltage 4 1 1

3 Dimensions 5 1 1

4 Battery Type 1 1 1

5 Weight 6 1 1

6 Colour 7 1 1

7 Standard or High Capacity 2 1 1

 

Just tried on a product I have, model #100. I've also set the model and id to be the same. So this item as products_id set to 100 and products_model set to 100.

 

This is my import file:

 

v_products_model v_products_extra_fields_name v_products_extra_fields_id v_products_extra_fields_value EOREOR

100 Capacity 1 1100mAh EOREOR

100 Voltage 2 9.6v EOREOR

100 Dimensions 3 100mm x 100mm x 100mm EOREOR

100 Battery Type 4 Li-ion EOREOR

100 Weight 5 200 grams EOREOR

100 Colour 6 Grey EOREOR

100 Standard or High Capacity 7 Standard EOREOR

 

 

This is the output from EP:

 

File uploaded.

Temporary filename: /tmp/phprShnzq

User filename: Book1.csv

Size: 356

1 | | | 1100mAh | Product Extra Fields Inserted

2 | | | 9.6v | Product Extra Fields Inserted

3 | | | 100mm x 100mm x 100mm | Product Extra Fields Inserted

4 | | | Li-ion | Product Extra Fields Inserted

5 | | | 200 grams | Product Extra Fields Inserted

6 | | | Grey | Product Extra Fields Inserted

7 | | | Standard | Product Extra Fields Inserted

 

Strange thing is it doesn't echo the model id back and seems to have empty columns.

 

This is the result in the product to product extra fields:

 

products_id products_extra_fields_id products_extra_fields_value

0 1 1100mAh

0 2 9.6v

0 3 100mm x 100mm x 100mm

0 4 Li-ion

0 5 200 grams

0 6 Grey

0 7 Standard

 

One thing I did try, I've been at this for a few days now, is install an older version of PEF and it sort of worked but only if I put the products_id field in the import file instead of the model number. I don't really want to use the id field and i'm sure the contrib is supposed to work with products_model.

 

As I said this Contrib will be great when I get it to work, if I can't sort it I may have to start adding extra fields in the products table and trying and displaying them as a table.

 

Any ideas would be great.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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...