Jump to content
netstep

EasyPopulate + Products Extra Fields - BEST

Recommended Posts

After using EP for a couple years, I was excited to try out the Products Extra Fields function in Easy Populate 2.76G.

2.76G is GREAT!!!

THANK YOU SO MUCH. :thumbsup:

 

However, the Products Extra Fields function isn't consistent with how the rest of this AMAZING tool works.

 

I was expecting the Extra Fields to be added to the EP export just like the attributes....as columns.

Then I could use Excel to add the data into those fields and upload.

 

v_attribute_values_id_8_3 | v_attribute_values_name_8_3_1 | v_attribute_values_price_8_3

 

I was expecting new columns like

v_products_extra_fields_id_1 | v_products_extra_fields_value_1 ....

 

Instead we got the basic columns, but the values are stacked in the columns:

Note below where the the same model# is used in 4 rows.

 

v_products_model | v_products_extra_fields_name | v_products_extra_fields_id | v_products_extra_fields_value | EOREOR

TP1 | Voltage | 4 | Testing Extra Field 1 | EOREOR

TP1 | Capacity | 5 | Testing Extra Field 2 | EOREOR

TP1 | Chemistry | 6 | Li-Ion | EOREOR

TP1 | Cell | 7 | Testing Extra Field 4 | EOREOR

 

What will it take to make the PEF data display horizontally so each row contains all the PEF values for 1 product...just like attributes?

 

I'm maxed out here, but I may have to make time for this because I'm using PEF much more...and this could save me some serious time.

HOWEVER, I'm willing to contribute CASH to someone if they want to set this up and add it to the contribution.


Sam M. - Seattle

Share this post


Link to post
Share on other sites

Hi netstep.

 

I am stumped on this as well, although it would appear that you've at least found a way for these extra fields to actually import via easy populate... I have installed both modules, both seem to be working independently... but I cant for the life of me ge thte extra fileds to export/import via EP.

 

Ive enabled Extra Fields in EP, and with the quick panel I can download an ExtraFields.csv... but that file is empty.

 

I added the columns as you've presented below, and as the are in the extrafields.csv... defining the name of the extra field, its id, and then the value for each, but can't get them to stick. EP says "updated" but the feild is still empty for each product.

 

Here's the deal, Im trying to add a upc code in addition to the model number... any suggestions or friendly pointers towards a tutorial. I am running in circles with this cart and the entire project was inherited....

 

Thanks in advance for any support and/or encouragement!

 

 

- Nate

Share this post


Link to post
Share on other sites

Hi

 

I have extra fields on my shop I am no expert but here is a copy of my file

 

My extra fields heading is v_attribute_options_name_5_1

 

My extra fields data is Finger Size

 

I hope this helps

 

 

"v_products_model" "v_products_image" "v_products_name_1" "v_products_description_1" "v_products_url_1" "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_1" "v_attribute_values_id_1_1" "v_attribute_values_name_1_1_1" "v_attribute_values_price_1_1" "v_attribute_values_id_1_2" "v_attribute_values_name_1_2_1" "v_attribute_values_price_1_2" "v_attribute_values_id_1_3" "v_attribute_values_name_1_3_1" "v_attribute_values_price_1_3" "v_attribute_values_id_1_4" "v_attribute_values_name_1_4_1" "v_attribute_values_price_1_4" "v_attribute_options_id_2" "v_attribute_options_name_2_1" "v_attribute_values_id_2_1" "v_attribute_values_name_2_1_1" "v_attribute_values_price_2_1" "v_attribute_values_id_2_2" "v_attribute_values_name_2_2_1" "v_attribute_values_price_2_2" "v_attribute_options_id_3" "v_attribute_options_name_3_1" "v_attribute_values_id_3_1" "v_attribute_values_name_3_1_1" "v_attribute_values_price_3_1" "v_attribute_values_id_3_2" "v_attribute_values_name_3_2_1" "v_attribute_values_price_3_2" "v_attribute_values_id_3_3" "v_attribute_values_name_3_3_1" "v_attribute_values_price_3_3" "v_attribute_values_id_3_4" "v_attribute_values_name_3_4_1" "v_attribute_values_price_3_4" "v_attribute_values_id_3_5" "v_attribute_values_name_3_5_1" "v_attribute_values_price_3_5" "v_attribute_values_id_3_6" "v_attribute_values_name_3_6_1" "v_attribute_values_price_3_6" "v_attribute_values_id_3_7" "v_attribute_values_name_3_7_1" "v_attribute_values_price_3_7" "v_attribute_values_id_3_8" "v_attribute_values_name_3_8_1" "v_attribute_values_price_3_8" "v_attribute_values_id_3_9" "v_attribute_values_name_3_9_1" "v_attribute_values_price_3_9" "v_attribute_values_id_3_10" "v_attribute_values_name_3_10_1" "v_attribute_values_price_3_10" "v_attribute_options_id_4" "v_attribute_options_name_4_1" "v_attribute_options_id_5" "v_attribute_options_name_5_1" "v_manufacturers_name" "v_categories_name_1" "v_categories_name_2" "v_categories_name_3" "v_tax_class_title" "v_status" "EOREOR"

"R21500/90" "R2150_90.jpg" "Rose Gold Emerald Ring" "A 9ct Rose Gold Emerald Ring set with a centre 7x5mm (0.28"x0.20" inches), two 6x4mm (0.24"x0.16" inches) & two 5x4mm (0.20"x0.16" inches) Emeralds. <p>Gold weight = Approx 4.2g</> <p>Total Emerald weight = Approx 2.4ct</>" 141 1 "07/25/2008 10:25:00" 100 1 "Metal" 1 "9ct Gold" 0 7 "14ct Gold" 30 8 "18ct Gold" 71 "Platinum" 5 "Gold Colour" 73 "18ct Yellow Gold" 74 "18ct White Gold" 7 "Carat Weight" 67 "0.20ct" 68 "0.25ct" 69 "0.50ct" 70 "1.00ct" 72 "0.25ct" 75 "0.30ct" 76 "0.40ct" 77 "0.70ct" 94 "0.35ct" 95 "0.75ct" 11 "Colour" 15 "Finger Size" "Emerald Rings" "Search by Gold Colour / Metal" "The Rose Gold Collection" "--none--" "Active" "EOREOR"

"R21500/90B" "R2150_90B.jpg" "Rose Gold Emerald Ring" "A 9ct Rose Gold Emerald Ring set with a centre 7x5mm (0.28"x0.20" inches), two 6x4mm (0.24"x0.16" inches) & two 5x4mm (0.20"x0.16" inches) Emeralds. <p>Gold weight = Approx 4.2g</> <p>Total Emerald weight = Approx 2.4ct</>" 144 1 "07/25/2008 10:25:00" 100 1 "Metal" 1 "9ct Gold" 0 7 "14ct Gold" 30 8 "18ct Gold" 71 "Platinum" 5 "Gold Colour" 73 "18ct Yellow Gold" 74 "18ct White Gold" 7 "Carat Weight" 67 "0.20ct" 68 "0.25ct" 69 "0.50ct" 70 "1.00ct" 72 "0.25ct" 75 "0.30ct" 76 "0.40ct" 77 "0.70ct" 94 "0.35ct" 95 "0.75ct" 11 "Colour" 15 "Finger Size" "Emerald Rings" "Search by Gold Colour / Metal" "The Rose Gold Collection" "--none--" "Active" "EOREOR"

Share this post


Link to post
Share on other sites

Do any of you guys know why I get this error message :

 

No products_model field in record. This line was not imported

 

but it does appear in my shop !

Share this post


Link to post
Share on other sites

Sorry I didn't need it in that format and the code is not written to split it out like that. I generate the file using msaccess to read the input file from the supplier and generate a file to be imported via EP.

 

The file needs to be in this format. It will work for 2 extra fields called List Price and Our Part No.

 

v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ

cts_extra_fields_value,EOREOR

CE42LM4WPR-E,List Price,1,£4495.00,EOREOR

VOGVFW165/SI,Our Part No,2,VOGVFW165,EOREOR


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

Share this post


Link to post
Share on other sites

Sorry I didn't need it in that format and the code is not written to split it out like that. I generate the file using msaccess to read the input file from the supplier and generate a file to be imported via EP.

 

The file needs to be in this format. It will work for 2 extra fields called List Price and Our Part No.

 

v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ

cts_extra_fields_value,EOREOR

CE42LM4WPR-E,List Price,1,£4495.00,EOREOR

VOGVFW165/SI,Our Part No,2,VOGVFW165,EOREOR

 

Seems a bit cumbersome to have a separate line in the file for each extra field. That would mean you would have 5 different lines in the file for EACH PRODUCT if you had 5 extra fields. Ouch.

 

Wouldn't it make sense to have had extra columns for each, just like the main import is done? How hard would it be to modify the existing code expect and handle a different format?


--

Douglas Hurst

Owner/Developer

Wildcard Web Development

Share this post


Link to post
Share on other sites

Probably not difficult at all.

 

When can we expect you amendment to be posted?

 

:-)

 

Cheers

 

G

@@WWDev


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

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

×