Urguent easy populate question please

[Mark-UK]

Hi all, im using the easy populate option to upload products, now in my spreadsheet i have a column for the product code, now what do i need to call that column for the product code to be placed in the "Products Model:" form field in my oscommerce sites admin.

 

Also can you have letters in there or is it just numbers you can have.

 

Thanks people

[Simplyeasier]

Hi all, im using the easy populate option to upload products, now in my spreadsheet i have a column for the product code, now what do i need to call that column for the product code to be placed in the "Products Model:" form field in my oscommerce sites admin.

 

Also can you have letters in there or is it just numbers you can have.

 

Thanks people

<{POST_SNAPBACK}>

 

 

Don't remeber the name offhand - but just look at the easypopulate.php code or alternatively do a download of products to a csv file and see what EP calls it .

 

Charles

[Mark-UK]

Thanks, not sure I understand though, anymore help or info you can give please.

 

thanks

 

Mrk

[Simplyeasier]

Thanks, not sure I understand though, anymore help or info you can give please.

 

thanks

 

Mrk

<{POST_SNAPBACK}>

 

 

If you have installed the EP contribution it has various options for downloading products from your database AS well as uploading new and amended products to your database,

 

I am saying if you dont know what the spreadsheet calls the various columns, just look at the EP code (if you are in a hurry) or do a download of products to a tab delimited file and see what EP call the columns that way before you add your new products and upload them.

 

Charles

[Mark-UK]

uk thanks, the easy populate version i have is this one.

 

Easy Populate Advanced 2.75 - Default Language English(1)

 

I have a friend who knows more about stuff like htis then me and im relaying all info you are giving me here so i theres anything you think i cna tell him that will help thahts would be great.

 

thanks people

[Mark-UK]

OK he says this:

 

I need to know what field that maps to in the database, and how you could import it using EasyPopulate

 

He is talking about the *Product model:* form field in my oscommerce admin, when i fill in the details for a new product there is the field isnt there for the product model, in easy populate how do we make sure the product model details get put in that section please.

 

What should the column be named as on the spreadsheet to be uploaded, i have a columns with all my product details in and 1 clumn is for the product model id number and obviously we want htis to be in teh form field product model in my site on the page for thaht product in admin.

[Simplyeasier]

OK he says this:

 

I need to know what field that maps to in the database, and how you could import it using EasyPopulate

 

He is talking about the *Product model:* form field in my oscommerce admin, when i fill in the details for a new product there is the field isnt there for the product model, in easy populate how do we make sure the product model details get put in that section please.

 

What should the column be named as  on the spreadsheet to be uploaded, i have a columns with all my product details in and 1 clumn is for the product model id number and obviously we want htis to be  in teh form field product model in my site on the page for thaht product in admin.

<{POST_SNAPBACK}>

 

 

I am going to answer one last time - IF you have installed easy populate

 

1) Download a sample of your products and the file will have the names you want. In fact this is highly recommended so you have the correct format of the Spread Sheet with the final column EOREOR that you can copy

 

2) Once you have downloaded the file - you can then COPY it and add your new products that you want to upload.

 

3) Of course if your database is empty and you do not have products to download - then you will have to look thro the easypopulate.php code for the column names or someone else on the forum who remembers the names will give them to you.

 

Charles

[Mark-UK]

ok sorted that now thanks folks. What i want to know now is in my product spreadsheet some of my products have options like colours and in my spreadsheet this is shown as each colour option is a seperate product with the same product code except the last digit, now when i upload my spreadsheet is it going to add these prodicts as seperate products or somehow make it 1 product with colour options.

 

So for instance row 10-15 of my spreadsheet is the same t shirt in 5 different colours, everthing is the same on each line from 10-15 except the final digit in the product code, BUT usually in my spreadsheet when a product doesnt have options its just 1 set of numbers in the product code column BUT when theres options like colours theres an extra set of digits and its the last digit thats different.

 

Example:

 

3455 (product with no options)

 

then any product with options in the spreadsheet has product code numbers like below.

 

2333 4555

2333 4556

2333 4557

2333 4558

 

So when i upload my spreadsheet will these products with options thaht appear on seperate lines be een and added as individual products so i have 5 products all the same t shirt in different colours or will my easy populate make it 1 product with colour options.

 

Phew and thanks folks.

[Guest]

all the posts regarding easypopulate need to go here:

 

http://www.oscommerce.com/forums/index.php?showtopic=64945

 

 

all the answers regarding easy populate are discussed in the thread, need to read thru it as all the same wqustions have been asked over and over in there.