Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

All -

 

I am having no success at importing the manufacturer_URL and manufacturer_image via EP. I named the column headers in the same fashion, E.G.: v_manufacturer_image v_manufacturer_URL , etc. I also tried: v_manufacturer_image_1 and also v_manufacturer_image_1_1

 

Your help would be very much appreciated! Probably a very easy fix for you all.

 

Thanks in advance,

 

Lance

 

(Dying in Chicago!)

Posted

Lance

 

Did you read the instructions that come with the contribution?

 

I believe it explains how to update additional fields.

 

G

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

Well, this sample from the documentation looks, not sure, to be related to adding additional fields for the product. So v_products_model exists in the CSV. I have v_manufacturer_image in the CSV.

 

So....if I'm on track here then I need the id and value. Both of which I do not know how to find out. Any help?

 

Extra Fields Contribution (Please ignore if you do not have this contribution installed)

--------------------------------------

There is no option to download product options using EP. To use EP to add and maintain Extra Fields create a file with the following columns.

 

'v_products_model' The model number for the product. You must add this to each line and all v_products_model must be unique.

'v_products_extra_fields_name' Case sensitive name of the extra Field. Must be exactly the same as the name of the extra field in the admin area.

'v_products_extra_fields_id' This is the tricky one, it is the extra fields ID. You will probably need to use PHPMyAdmin to find out what it is.

'v_products_extra_fields_value' The value you want for the extra field.

Posted

That bit is for updating the product extra fields table

 

// The following setup will allow you to define any additional

// field into the "products" and "products_description" tables

// in your shop. If you have installed a custom contribution

// that adds fields to these tables you may simply and easily add

// them to the EasyPopulate system.

 

Set up a product on your shop and download a file, see if the fields are already being processed by EP.

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

I did that, and the manufacturers_image and manufacturers_URL fields are not being processed. Manufacturers_name is being processed however.

 

v_products_model v_products_name_1 v_manufacturers_name EOREOR

 

 

I would imagine the process would be similiar though. I am just not experienced enough at this point. These two fields are the only thing I'm having an issue with. EP works great, and until I found it I just beat my head against the wall trying to get data uploaded.

Posted

I'm having a similar problem trying to upload a CSV with six custom fields. I set up easypopulate.php according to instructions but it seems something is being left out. I might end up using phpMyAdmin. Meanwhile, I added the six custom fields to admin/categories.php and am able to individually add items through admin, but what a long process for the number of items we have in our CSV file.

Posted

So did you go and find the section in the documentation for how to update new fields?

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
So did you go and find the section in the documentation for how to update new fields?

Indeed I did. The documentation starting on line 245 in easypopulate.php appears to be very thorough but something is amiss.

Is there perhaps more documentation I could read besides this:

// ********************
// ** products table **
// Lets say you have added a field to your "products" table called
// "products_upc". The header name in your import file will be
// called "v_products_upc".  Then below you will change the line
// that looks like this (without the comment double-slash at the beginning):
// $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export
//
// TO:
// $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC' );
//
// If you have multiple fields this is what it would look like:
// $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC', 'products_restock_quantity' => 'Restock' );
//
// ********************************

Posted

What is amiss?

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
What is amiss?

I've created a CSV file with custom fields, however, when I use the Easy Populate tool, in Admin, it won't import my custom fields. I made all the necessary additions to the code for easypopulate.php and can't figure out why these fields aren't being imported.

Posted (edited)

perhaps if you post the first 3 lines of import file and the code changes you made.....

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
perhaps if you post the first 3 lines of file the code changes you made.....

 

Thanks for taking a look. Here it is:

// $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export
$custom_fields[TABLE_PRODUCTS] = array( 'products_length' => 'Length', 'products_end' => 'End', 'products_wattage' => 'Wattage', 'products_reflector' => 'Reflector', 'products_uvb' => 'UVB', 'products_rated' => 'Rated' );
$custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export

Posted

Missed a few words

 

perhaps if you post the first 3 lines of import file and the code changes you made.....

 

What happens when you import the file?

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
Missed a few words

 

perhaps if you post the first 3 lines of import file and the code changes you made.....

 

What happens when you import the file?

Here are the first and only four lines of the test CSV I created. When I import the file, everything gets imported except for the six custom fields:

v_products_model,v_products_length,v_products_end,v_products_wattage,v_
products_reflector,v_products_uvb,v_products_rated,v_categories_name_1_1,v_catego
ries_name_1_2,v_products_name_1,v_products_price,v_products_weight,eoreor
test0004a,F73,RDC,120,N,5.5,1200,Radiance Lamps,Radiance Test,Radiance Test Product 004,16.95,1,eoreor
test0005a,F71,BP,100,N,3.0,1200,Radiance Lamps,Radiance Test,Radiance Test Product 005,14.95,1,eoreor
test0006a,F59,BP,80,N,5.0,1200,Radiance Lamps,Radiance Test,Radiance Test Product 006,14.95,1,eoreor

 

Here is the modified code from easypopulate.php:

// $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export
$custom_fields[TABLE_PRODUCTS] = array( 'products_length' => 'Length', 'products_end' => 'End', 'products_wattage' => 'Wattage', 'products_reflector' => 'Reflector', 'products_uvb' => 'UVB', 'products_rated' => 'Rated' );
$custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export

 

Here's the link to the site: www.tanninglampstore.com. It's still under development.

Posted

i think that the easypopulate instructions tell you how to address getting extra fields from your csv data into the database, but before you can do that, you have to add these custom fields to the database. so i think so many people used the "Extra Product Fields" contribution that the person who built EasyPopulate says in his/her instructions, how to use EasyPopulate is you've got Extra Product Fields you want to populate with data. So do you folks install the Extra Product Fields add-on and are now trying to get EasyPopulate to work with those fields? Or are you expecting the EasyPopulate itself allows you to create extra fields to store the additional data you want to upload?

  • 2 weeks later...
Posted

Had NO idea that was an additional add-on. It came off as a feature of EasyPopulate. :huh: I will download and investigate now. Thanks for the clarification!

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