Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

excell price list


nikitas

Recommended Posts

i have a price list with description and images in excell , how can i insertet it automatically in my shop without make it piece by piece ?

 

Well - do these products already exists in the db ? If so, you'll need the product id number in your file as well.

If not, the product_id number will need to be auto-incremented in the database.

 

You can export the file to something with a delimited. I prefer pipe :

|

but you can use a comma or whatever.

 

Write a small script that read in the file, one line at a time, and delimit the data by your delimiter.

For each line read, do an insert.

 

pseudocode :

 

while (read each line in file)

split the file on your delimiter

$sql_query = update products set description = (?) ,price = (?), images = (?)

$sql_query .= where <this is where you need to specify your prodcut id number>

 

Or - you could leave the where clause out, and then let the db assign a value. You'll also need to chnage your update statment into an insert statement. :

insert into products (description,price,images) values (?,?,?)

 

http://chipmunk-scripts.com/board/index.ph...=43&ID=9602

 

Corrie

Link to comment
Share on other sites

these products are not in the db .

can i use the easy populate ?

 

I used easy populate and excel import. Both didn't work for me. If you manage to get either to work can you post in this topic how you done it? It's impossible to ask in the easy populate thread as its just 88 pages full of people asking the same 5 questions of which none of them have been answered.

 

My particular problem was with excel import as in you import the products, they show up in the database but not on the site.

Link to comment
Share on other sites

I used easy populate and excel import. Both didn't work for me. If you manage to get either to work can you post in this topic how you done it. It's impossible to ask in the easy populate thread as its just one massive thread full of people asking the same questions.

 

 

According to the doc it says the product already need to exist :

Easy Populate & Products Attributes

 

Easy Populate makes it simple to populate your OSC store with products without using the web interface at all.

 

Easy Populate lets you download all your products into a csv file, edit them in the spreadsheet of your choice, and the reupload them to update your products, changing prices, categories, quantities, etc.

 

But - as I said - you could easily modify it I'm sure to update your file to have a column for the product Id.

Just create a new column in your spread sheet that holds the id number.

Can Excel populate this value ?

 

Of course - if you do this, then the products_to_categories tabler will not be updated, and all the products will be under a single category at the root of your store.

 

Do you need help in writing a script to do this ?

If so, please provide three or four rows from your excel table so I can see the format.

 

Corrina

Link to comment
Share on other sites

According to the doc it says the product already need to exist :

Easy Populate & Products Attributes

 

Easy Populate makes it simple to populate your OSC store with products without using the web interface at all.

 

Easy Populate lets you download all your products into a csv file, edit them in the spreadsheet of your choice, and the reupload them to update your products, changing prices, categories, quantities, etc.

 

But - as I said - you could easily modify it I'm sure to update your file to have a column for the product Id.

Just create a new column in your spread sheet that holds the id number.

Can Excel populate this value ?

 

Of course - if you do this, then the products_to_categories tabler will not be updated, and all the products will be under a single category at the root of your store.

 

Do you need help in writing a script to do this ?

If so, please provide three or four rows from your excel table so I can see the format.

 

Corrina

 

Hi there,

 

I'm actually using Excel Import not easy populate. Easy populate just gave me too many errors and I gave up.

 

Excel import works, the products are in my database, but they are not showing.

 

heres the file i uploaded

 

manufacturer_name	manufacturers_image	categories1_name	categories2_name	categories3_name	model_no	web_pic	list_price	weight	products_name	products_description
	Pure Essential Oils			1	0	3.99		Anise Star  (Illicium verum)	"From the seed. A winter oil, useful when blended with other essential oils for chest rubs. It has a warm, spicy and liquourice aroma. Use in moderation. "
	Pure Essential Oils			2	basil.jpg	6.25		Basil (Ocimum basilicum)	From the leaf. An uplifting oil and helpful during times of concentration. It has a warm and spicy aroma. Use in moderation.
	Pure Essential Oils			3	bay.jpg	5.99		Bay (Pimenta racemosa)	"From the leaf. Known for its qualities as a hair and scalp tonic. It has a light, sweet and delicately spiced aroma."
	Pure Essential Oils			4	benzoin.jpg	3.85		Benzoin (Styrax benzoin)	From the resin. Useful for chapped skin and inhalations. It has a sweet warm aroma reminiscent to vanilla.
	Pure Essential Oils			5	bergamot.jpg	5.99		Bergamot (Citrus aurantium)	"From the fruit peel. A most refreshing oil and one of the oils that has a deodorizing quality. A calming oil, which is also uplifting."

 

Quite a lot of stuff has been loaded, can i fix it in phpmyadmin so that it'll show up?

Link to comment
Share on other sites

I'm actually using Excel Import not easy populate. Easy populate just gave me too many errors and I gave up.

Excel import works, the products are in my database, but they are not showing.

 

heres the file i uploaded

 

manufacturer_name	manufacturers_image	categories1_name	categories2_name	categories3_name	model_no	web_pic	list_price	weight	products_name	products_description
	Pure Essential Oils			1	0	3.99		Anise Star  (Illicium verum)	"From the seed. A winter oil, useful when blended with other essential oils for chest rubs. It has a warm, spicy and liquourice aroma. Use in moderation. "
	Pure Essential Oils			2	basil.jpg	6.25		Basil (Ocimum basilicum)	From the leaf. An uplifting oil and helpful during times of concentration. It has a warm and spicy aroma. Use in moderation.
	Pure Essential Oils			3	bay.jpg	5.99		Bay (Pimenta racemosa)	"From the leaf. Known for its qualities as a hair and scalp tonic. It has a light, sweet and delicately spiced aroma."
	Pure Essential Oils			4	benzoin.jpg	3.85		Benzoin (Styrax benzoin)	From the resin. Useful for chapped skin and inhalations. It has a sweet warm aroma reminiscent to vanilla.
	Pure Essential Oils			5	bergamot.jpg	5.99		Bergamot (Citrus aurantium)	"From the fruit peel. A most refreshing oil and one of the oils that has a deodorizing quality. A calming oil, which is also uplifting."

 

Quite a lot of stuff has been loaded, can i fix it in phpmyadmin so that it'll show up?

 

Well - based on these lines, the number of titles do not match the number of columns of content.

Does your content look good when you view it in phpMyAdmin ?

 

The uploading rules says :

1. The data must be tab delimeted

8. Keep the sequence of the columns as it is given below. If any of the column doesnot contain any data.

Leave it blank but donot remove it from the list

 

This makes no senese. How can you retain the columns, AND leave out content data if the file is tab delimited ? A computer will read 2 tabs just the same as one tab! lol

 

Corrie

Link to comment
Share on other sites

Well - based on these lines, the number of titles do not match the number of columns of content.

Does your content look good when you view it in phpMyAdmin ?

 

The uploading rules says :

1. The data must be tab delimeted

8. Keep the sequence of the columns as it is given below. If any of the column doesnot contain any data.

Leave it blank but donot remove it from the list

 

This makes no senese. How can you retain the columns, AND leave out content data if the file is tab delimited ? A computer will read 2 tabs just the same as one tab! lol

 

Corrie

 

The data is all there in phpmyadmin, the uploaded products are sitting in the products table with my 2 test products i inputted by hand.

 

All the values are identical but yet they still don't show in the admin or site.

Link to comment
Share on other sites

The data is all there in phpmyadmin, the uploaded products are sitting in the products table with my 2 test products i inputted by hand.

 

All the values are identical but yet they still don't show in the admin or site.

top

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...