nikitas Posted February 24, 2007 Share Posted February 24, 2007 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 ? Link to comment Share on other sites More sharing options...
Guest Posted February 24, 2007 Share Posted February 24, 2007 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 More sharing options...
nikitas Posted February 24, 2007 Author Share Posted February 24, 2007 these products are not in the db . can i use the easy populate ? Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 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 More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 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 More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 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 More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 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 More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 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 More sharing options...
Guest Posted February 27, 2007 Share Posted February 27, 2007 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.