Latest News: (loading..)
VJ

Easy Populate & Products Attributes

9,080 posts in this topic

Now that I got the EP working, my next problem are the pictures that go with the product. Rather vague as a description isn't it? So let me try and explain what am trying to accomplish and perhaps someone has encountered the same situation and (hopefully) found a solution to this.

 

Below is an extract from the spreadsheet listing the image

 

v_products_model v_products_image v_products_name_4 v_products_description_4 v_products_url_4 v_products_name_1 v_products_description_1

DWWI070 Dwwi070.jpg Hybrid Wood Wilson Men’s ProStaff DC Hybrid Wood with Graphite Shaft www.wilson.com Hybrid Wood Wilson Men’s ProStaff DC Hybrid Wood with Graphite Shaft

 

This image is inserted into the shop without any problems because the picture (DWWI070.JPG) is located in the default images folder. However since we are talking about a lot of products from different suppliers, I'd like to get the pictures organized in a folder per supplier. So for instance, pictures of products from supplier wilson should be located in images\wilson.

 

When I however use this location in the spreadsheet, no pictures shows up when uploading data to the database. I tried with different formats, i.e. \images\wilson\DWWI070.jpg, images\wilson\DWWI070.JPG, \wilson\DWWI070.JPG etc. None of these get me the picture.

 

Does anybody have an idea if above is possible and if so, how this can be accomplished?

 

Tks

Share this post


Link to post
Share on other sites
Sorry! I realise it is a setting in easypopulate.php but what do I do to set the status to active?

Hmm, I guess the important part of the "how to ask for help" section of the docs in this case would be a link to your import file (or sample there of). (do not just post the data)

Share this post


Link to post
Share on other sites
Now that I got the EP working, my next problem are the pictures that go with the product. Rather vague as a description isn't it? So let me try and explain what am trying to accomplish and perhaps someone has encountered the same situation and (hopefully) found a solution to this.

 

Below is an extract from the spreadsheet listing the image

 

v_products_model v_products_image v_products_name_4 v_products_description_4 v_products_url_4 v_products_name_1 v_products_description_1

DWWI070 Dwwi070.jpg Hybrid Wood Wilson Men’s ProStaff DC Hybrid Wood with Graphite Shaft www.wilson.com Hybrid Wood Wilson Men’s ProStaff DC Hybrid Wood with Graphite Shaft

 

This image is inserted into the shop without any problems because the picture (DWWI070.JPG) is located in the default images folder. However since we are talking about a lot of products from different suppliers, I'd like to get the pictures organized in a folder per supplier. So for instance, pictures of products from supplier wilson should be located in images\wilson.

 

When I however use this location in the spreadsheet, no pictures shows up when uploading data to the database. I tried with different formats, i.e. \images\wilson\DWWI070.jpg, images\wilson\DWWI070.JPG, \wilson\DWWI070.JPG etc. None of these get me the picture.

 

Does anybody have an idea if above is possible and if so, how this can be accomplished?

 

Tks

 

Ok .. specifying this format in the spreadsheet does the trick /[subfolder]/[image_name]

Share this post


Link to post
Share on other sites
Hmm, I guess the important part of the "how to ask for help" section of the docs in this case would be a link to your import file (or sample there of). (do not just post the data)

 

It's alright I did not realise that I had to add a column v_staus to my attributes download as the Complete had it already there. I got myself mixed up with how it works.

 

Have another question though. Before using EP I had installed Actual prices which removed the prefix. After using EP the prefix has returned so any ideas on how can I remove it?

Share this post


Link to post
Share on other sites
It's alright I did not realise that I had to add a column v_staus to my attributes download as the Complete had it already there. I got myself mixed up with how it works.

 

Have another question though. Before using EP I had installed Actual prices which removed the prefix. After using EP the prefix has returned so any ideas on how can I remove it?

sounds like something I should look at the status logic. it should default to active if the v_staus column is not included.

 

what are you refering to by "the prefix" ? to what?

Share this post


Link to post
Share on other sites
sounds like something I should look at the status logic. it should default to active if the v_staus column is not included.

 

what are you refering to by "the prefix" ? to what?

 

The prefix on the price of the attributes.

Share this post


Link to post
Share on other sites
The prefix on the price of the attributes.

This is the same concern I have (see previous post quoted below)

Can someone who knows the code in this contrib real well please explain how the attributes prices are collected and display with this contrib?

Here's why I ask ...

 

I'm using the Actual Attributes Price contrib. With it, the options menu diplays the actual price of an option (with no prefix), instead of the price difference (with a + or -). To do this, I just leave the price prefix blank when adding an attribute to an item in the osCommerce web-based admin. Basically, the attribute price replaces the normal price, instead of being added or subtracted from it.

With easy populate, when I add an attribute price to the spread sheet without adding a price prefix, and then I upload it, it shows up with a + in the attribute drop down menu on the product page. Is it added automatically? If so, how can I turn that off and stop the addition and subtraction of the attribute price? When there is no prefix, I want the product price to be replace.

 

Thanks!

Share this post


Link to post
Share on other sites
The prefix on the price of the attributes.

 

So folks using actual prices contrib enter attributes differently then everyone else. EP will not be able to compensate for that.

 

you can prevent the import of the addition and subtraction signs

near line 2767 there are 2 places (in 2 lines near here), find

'" . $attribute_values_price_prefix . "'

 

replace with:

''

(2 single quotes)

Share this post


Link to post
Share on other sites
So folks using actual prices contrib enter attributes differently then everyone else. EP will not be able to compensate for that.

 

you can prevent the import of the addition and subtraction signs

near line 2767 there are 2 places (in 2 lines near here), find

'" . $attribute_values_price_prefix . "'

 

replace with:

''

(2 single quotes)

 

Thanks ever so much for that it works perfectly!!!!

 

Have another question. I am not using default weights and I have 'add weights to attributes' so I can not use the weights column in the EP excel.

I decided to experiment and tried adding a column after each of my attributes and named it v_attributes_values_weight_?_? the question marks being the various values of the attribute. This did not work. Any ideas on how to make this work?

Mind you I only inserted the column after each attribute value I was using. Maybe I need to insert the column on all of the attribute values.

The v_attribute_values_name_?_?_? has 3 numbers after it. I supoose I could try that as well.

Any ideas on whether what I want to achieve is possible?

Share this post


Link to post
Share on other sites

Ha ha ha!

It would also help to alter the easypopulate file but up until 3 months ago I had never even heard of php. Would really appreciate help on this.

Share this post


Link to post
Share on other sites
v2.76e Released ! Anyone using v2.76d, and are having trouble, please update and enjoy the more readable docs included.

 

Most modifications were made because of problems reported in the forum. Thanks to all that helped debug.

 

I'll bet y'all thought I wasn't keeping track....

 

+ cleaned up some redundant code.

+ cleaned up the docs for readability.

+ Removed various excess files.

+ fixed a problem where the currency precision was being ignored.

+ Added a currency precision configuration item.

+ Added code to pick the Excel list separator based on the language choice in your web browser.

see post 4939: http://forums.oscommerce.com/index.php?sho...244&st=4920

+ Removed all global use for those with global registration restricted servers.

see post: (almost every post) :)

+ Set default Products Model to 12 since orginal osC database size is 12 chars - thanks HallMarc

+ Set Froogle's URLs to osC standard constants eliminating user configuration - thanks HallMarc

+ Fixed Froogle's outdated code - thanks HallMarc

see post: 4854 http://forums.oscommerce.com/index.php?sho...mp;#entry984338

+ Fixed an issue where Product Descriptions and URLs were being blanked when only the

Product Name was uploaded.

+ Fixed problem with PHP 5 and array_walk() function reported in forum.

See post: 4827 http://forums.oscommerce.com/index.php?sho...mp;#entry982309

(note: function name has changed to avoid confusion)

+ cleared-up an issue with the Date Added being assigned to the Date Available & other date issues.

+ Fixed issue with CURRENT_TIMESTAMP failing to set the Date Added date to a product import.

See post: 5036 http://forums.oscommerce.com/index.php?sho...244&st=5020

(Note: I changed this fix since CURRENT_TIMESTAMP didn't work with all servers)

+ Fixed issue with products status not keeping original value.

See Post: 5315 http://forums.oscommerce.com/index.php?sho...p;#entry1030113

+ Fixed a problem where category insertions where not handled correctly in multi-language shops.

This does not yet offer multi-language category support. :( But will at least setup the

first imported language and other languages so that the admin works correctly.

See post: 5671 http://forums.oscommerce.com/index.php?sho...p;#entry1059786

+ Changed the working (current) language to be the current admin language instead of the

hidden osC default language setting. This should allow those with multiple Category languages

to work with them by changing the current language from the admin main page when importing that

specific language. OK, this and the last fix makes it possible to work with multi-language cats.

But its still not an ideal solution.

See post: 5503 http://forums.oscommerce.com/index.php?s=&...t&p=1042183

+ Fixed a bug where negative product attributes where being imported with a double negative.

See Post 5517: http://forums.oscommerce.com/index.php?sho...244&st=5500

+ fixed a problem with inclusion of the easypopulate functions file. function_exists syntax was wrong.

+ Added support for category images. (v_categories_image_1, v_categories_image_2, etc.)

+ Included pui30576's fix for SPPC (9 Apr 2007)

+ Included OPTIONAL Extra Field Contribution support offered by minhmaster DEVSOFTVN

+ Included support for product deletes thanks to bruyndoncx

see http://forums.oscommerce.com/index.php?sho...=235945&hl=

+ Included a contribution by PerlSOL to populate a dropdown list from your temp directory

for easy picking uploaded files for import.

see post: 5908 http://forums.oscommerce.com/index.php?sho...p;#entry1101458

 

SUPPORT

I will be watching this thread for support. I will be supporting this version only.

Due to time constraints I will help find problems with this version as I uploaded it and I will not be helping integrate other contributions, sorry. I'd be more then happy to integrate code you have developed for other contributions.

 

Hi surfalot,

 

Thanks very much for this, I managed to get EP working for the first time on a test store.

I've tried several times before but this is the first time I've been able to download and upload data sucessfully.

 

Thankyou its really made my week.

 

PS

 

I have noticed you didn't keep the nice admin control panel (stored in DB) features that were added by Moosey Jude - I feel this is a shame as it was a much nicer way. Instead you have reverted back to making changes to the easypopulate file.

WARNING to those who have installed Easy Populate 2.76d-MS2 with Admin - if you do 'upgrade' you will loose these features.

Share this post


Link to post
Share on other sites
Thanks ever so much for that it works perfectly!!!!

 

Have another question. I am not using default weights and I have 'add weights to attributes' so I can not use the weights column in the EP excel.

I decided to experiment and tried adding a column after each of my attributes and named it v_attributes_values_weight_?_? the question marks being the various values of the attribute. This did not work. Any ideas on how to make this work?

Mind you I only inserted the column after each attribute value I was using. Maybe I need to insert the column on all of the attribute values.

The v_attribute_values_name_?_?_? has 3 numbers after it. I supoose I could try that as well.

Any ideas on whether what I want to achieve is possible?

for any column you have in the spreadsheet, you need code in EP to process it. just adding a column won't help. unfortunately I can't afford the time to help everyone integrate their contrib-du Jour. At the moment, just trying to get the base code to work for everyone.

Edited by surfalot

Share this post


Link to post
Share on other sites
Hi surfalot,

 

Thanks very much for this, I managed to get EP working for the first time on a test store.

I've tried several times before but this is the first time I've been able to download and upload data sucessfully.

 

Thankyou its really made my week.

 

PS

 

I have noticed you didn't keep the nice admin control panel (stored in DB) features that were added by Moosey Jude - I feel this is a shame as it was a much nicer way. Instead you have reverted back to making changes to the easypopulate file.

WARNING to those who have installed Easy Populate 2.76d-MS2 with Admin - if you do 'upgrade' you will loose these features.

the problem with that is documentation. we only have 255 chars worth of text available to the admin config options. most features needed more docs, which means less posts and confusion. Too many folks will either read the docs or go through the setting, but not both. So I headed them off at the pass.

 

It also helps with those that manage many sites on the same server. In that case, all we have to do is copy the files from site to site and don't have to deal with setup admin vars.

Share this post


Link to post
Share on other sites
the problem with that is documentation. we only have 255 chars worth of text available to the admin config options. most features needed more docs, which means less posts and confusion. Too many folks will either read the docs or go through the setting, but not both. So I headed them off at the pass.

 

It also helps with those that manage many sites on the same server. In that case, all we have to do is copy the files from site to site and don't have to deal with setup admin vars.

 

I supose from that angle it make v good sense.

 

I'm now stuck on a few attribute issues.

I understand how the headings work and have managed to upload attributes sucessfully.

However, lets say products have size as an attribute with small, medium and large as options - and I want to add X Large to some of them.

This sounds pretty simple... so I create the CSV (like below) file & upload - all seems successfull - but its not, the size attribute vanishes on those products when viewed.

 

v_products_model......prod906
v_status......Active
v_attribute_options_id_1......1
v_attribute_options_name_1_1......Size
v_attribute_values_id_1_4......4
v_attribute_values_name_1_4_1......X Large
v_attribute_values_price_1_4......20
EOREOR......EOREOR

 

Am I asking EP to do the impossible? or have I made a mistake?

Many thanks

Share this post


Link to post
Share on other sites
for any column you have in the spreadsheet, you need code in EP to process it. just adding a column won't help. unfortunately I can't afford the time to help everyone integrate their contrib-du Jour. At the moment, just trying to get the base code to work for everyone.

 

No problem, thanks for the help thus far, I may even have a crack at it myself! :D

Share this post


Link to post
Share on other sites

Would anyone know why my categories are not being created? Easy Populate 2.76e-MS2 (with attributes) r1

 

If I manually create them in the admin, then the products go into the correct categories. At this point, if I make a complete download, the categories show up in the csv. Now if I truncate all the products and categories tables, and reupload the same file, the products will go in but it will not create the categories. If I look at the tables, the categories table has data, but the categories_descriptions is empty and that must be the problem. It does not throw any errors when uploading, and finishes like it went ok. but the categories didn't make it once again.

 

Ideas? Thanks!

Share this post


Link to post
Share on other sites

I should add... CentOS Linux, Mysql 4.1, register globals ON, PHP 4.3.9, dedicated server.

Share this post


Link to post
Share on other sites

Ok, I tried stripping the INSERT INTO table_categories_descriptions at about line 2300 back to the older pre-language selection code. That helped by at least writing to that table, but it was writing the language_id in as 0 instead of 1. I only use English. When I edited the 0 to a 1 on a product, it would show the category. So I hacked in a line $epdlanguage_id = "1"; to force it to use a 1. It is working now, but it is a kludge.

Share this post


Link to post
Share on other sites

I installed this and everything but the status works. It kicks everything to Active. I have lots of seasonal products that I do not want to delete.

 

The downloaded CSV shows them as Inactive, for a test, I uploaded the file without any mods and it turns the status. ALL my products have a model number.

Share this post


Link to post
Share on other sites

please help

 

i am builidng my store and using Ulatra pics

 

now if you look at the images

 

www.vivastyle.co.uk

 

it shows in the category listing but not in v__products_image_med

 

and it is trying to call all other images sizes even though they are not filled in on the EP spreadsheet

 

any help is gratefully appreciated

Share this post


Link to post
Share on other sites

I am trying to modify this to suit my store, I have sppc, volume discounts, product tabs, groups and more.. I want to adapt my version to accomodate all the fields i have in my database. So i can easily import/export.

 

Here's the fields in products table that i need to add:

 

products_retail_price

products_cost

products_price1

products_price2

products_price3

products_price4

products_price5

products_price6

products_price7

products_price8

products_price1_qty

products_price2_qty

products_price3_qty

products_price4_qty

products_price5_qty

products_price6_qty

products_price7_qty

products_price8_qty

products_qty_blocks

products_spec

products_to_rss

 

Here's the tables in products_description that i need to add

 

products_moreinfo

products_extra1

products_manual

products_extraimage

products_musthave

products_spec

 

and in my products_groups:

 

customers_group_id

customers_group_price

products_price1

products_price2

products_price3

products_price4

products_price5

products_price6

products_price7

products_price8

products_price1_qty

products_price2_qty

products_price3_qty

products_price4_qty

products_price5_qty

products_price6_qty

products_price7_qty

products_price8_qty

products_qty_blocks

 

I realize you cant sit down and write it out like i need, but some advise on which section i should edit for each part would be helpful. I have tried all previous versions to get it to support all of my fields and have failed every time. I'm hoping you can help. I need it to be able to do a full export of all fields plus the ones i listed and as well be able to import them. please help.

Share this post


Link to post
Share on other sites

Hi guys, i just installed Easy Populate 2.76e-MS2 (with attributes) r1 and after i've done all the steps i got this error while trying to access the easy populate menu

 

Error message:

Premature end of script headers: easypopulate.php

 

I'm a newbie at this, please let me know what other info should i post, thanks in advance

Share this post


Link to post
Share on other sites

First of all, thanks for the GREAT contribution! It's been a real help.

 

The only concern I have is that I'm having a hard time having my attributes sort properly. Does EP offer a solution for this?

Share this post


Link to post
Share on other sites

EXPORT

 

It's been a while since I've used osCommerce, but getting back into it, I'm looking to import and export products from two sites. It appears I followed the instructions and am getting an error upon product export.

 

1065 - Query was empty



[TEP STOP]

 

IMPORT

 

Upon import, using the "sample_output_file.csv" and "sample_output_file.txt" files, exchanging the default data therein to import four test products, no products we imported. I have tested several other options, such as the Excel Import 1.51 (http://forums.oscommerce.com/index.php?showtopic=27305&hl=csv), but the Excel Import 1.51 does not have a working export tool and doesn't have the extensive data manipulation tools this add on does. I've read through many of the pages here but have not been able to figure out what the issues are with my situation. Any advice?

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