dyn Posted May 24, 2012 Share Posted May 24, 2012 Hi All, Thanks in advance for any support. Using prestashop v=1.4.8.2, I'm currently able to successfully import data using csv and the import tool. However, I may be mistaken, but is there no way to set the price via a bulk upload using csv? I've exported the fields from the sql table to view them, and I can already see that there are missing fields in the "Available Fields" as well as the "Column" drop down section of the "Your Data" screen of the csv import for products. Is there not a way to bulk insert price -> product using csv and the import tool? I've searched the forum and google for several hours now. Any assistance would be much appreciate. Thank you, Dayan Link to comment Share on other sites More sharing options...
wippa Posted May 24, 2012 Share Posted May 24, 2012 I have some problems understanding your question/problem because i have 0 skill on English. I dont know why you cant put prices when using csv import tool. You can import all data related to product, and update it, including price, stock or any data you provide into csv. Link to comment Share on other sites More sharing options...
dyn Posted May 24, 2012 Author Share Posted May 24, 2012 Thanks for the response. I must be missing something then. These are the "Available Fields" in the Product Sample csv: ID Active (0/1) Name * Categories (x,y,z...) Price tax excl. Tax rules id Wholesale price On sale (0/1) Discount amount Discount percent Discount from (yyyy-mm-dd) Discount to (yyyy-mm-dd) Reference # Supplier reference # Supplier Manufacturer EAN13 UPC Ecotax Weight Quantity Short description Description Tags (x,y,z...) Meta-title Meta-keywords Meta-description URL rewritten Text when in-stock Text if back-order allowed Available for order Date add product Show price Image URLs (x,y,z...) Delete existing images (0 = no, 1 = yes) Feature Only available online Condition Can you tell me which one should I put the actual price in? Link to comment Share on other sites More sharing options...
wippa Posted May 24, 2012 Share Posted May 24, 2012 If you are using taxes (is not really obviosly) you have to choose same option than if you don't choose. (Price tax excluded) > You need that price base (No total price available because total always is calculed in base of discount and like this) Now you have to choose (Id tax) > This is the id of defined tax table. If you use only one type, you will get 1. You can add this manually into csv before import. You may set the tax rule if you import over new store, because tax rules will be empty. Can you understand my poor English? Link to comment Share on other sites More sharing options...
dyn Posted May 25, 2012 Author Share Posted May 25, 2012 Thanks. Actually, the "Price Tax Excl." field is filled with prices for each product. I'm testing 28 products, and they all have prices referenced in that column. This is what's confusing to me, as I did that before I even posted here. Per your suggestion, I also placed a "0" or "1' in the "Tax Rules ID" column, and still no go. No price shows up on any product. Additionally, the "Show Price" column has a 1 in each field, as does the "Available for Order" column, so the price of 0.00 is showing up on each product, but not reflecting the actual price. Link to comment Share on other sites More sharing options...
dyn Posted May 25, 2012 Author Share Posted May 25, 2012 HI All, I've attached an example of one product i'm importing. The "Price Tax Excl." column is all I need. Perhaps someone can guide me to the correct column. Thank you kindly. products.txt Link to comment Share on other sites More sharing options...
dyn Posted May 29, 2012 Author Share Posted May 29, 2012 bump... can anyone help, please? Link to comment Share on other sites More sharing options...
wippa Posted June 8, 2012 Share Posted June 8, 2012 (edited) Im seeing. Patience... Use your time searching instead reply yourself. Thanks Check the order. I think is not correct. Read your file with care. Edited June 9, 2012 by wippa (see edit history) Link to comment Share on other sites More sharing options...
wippa Posted September 5, 2012 Share Posted September 5, 2012 Any new? Link to comment Share on other sites More sharing options...
arjun02patel Posted September 20, 2012 Share Posted September 20, 2012 What the catch if i want to add short description to all of my products that are already at my shop/ database with description, that having no short descriptions. i want to add just short descriptions from the CSV upload to all the products that i'm having at my shop.. Give me solution for best... Thanks... Link to comment Share on other sites More sharing options...
wippa Posted September 20, 2012 Share Posted September 20, 2012 I read again from start. You havent to put any currency simbol into csv import when import again to web. Explanation: When you export from web, a option gives you posibility to format price, BUT, data extracted is only a NUMBER, like 10, not 10€$. Only a number is allowed from import. When you see currency simbol into excel program, si not, is a cell formatting. If you click into price, will see only a number value type. A dude from this, is... do you write manually $ simbol to price cell?? You have two options at least. 1. Do not use money format option. 2. Select row into excel, use "search and replace". Search for € or $ and replace with "blank" (None, blank is not space ) any time you import. If that does not solve your problem, maybe i need see problem into my screen to understand. Link to comment Share on other sites More sharing options...
wippa Posted October 26, 2012 Share Posted October 26, 2012 Good look man Link to comment Share on other sites More sharing options...
Recommended Posts