lse123 Posted December 19, 2014 Share Posted December 19, 2014 PrestaShop combinations are separate Product IDs? If I have Photographs for sale - A2, A3, A4 - size prints combinations, I have to create per product one Product ID or three(3)...Product IDs (entries) in csv import file? Link to comment Share on other sites More sharing options...
tuk66 Posted December 20, 2014 Share Posted December 20, 2014 Combinations (attributes) are stored in several tables - ps_attribute, ps_attribute_lang, ps_product_attribute, ps_product_attribute_combination and more and the ID you want to know is id_product_attribute The product_id, and eventually product_attribute_id fields are stored in every order detail. Link to comment Share on other sites More sharing options...
lse123 Posted December 20, 2014 Author Share Posted December 20, 2014 (edited) " The product_id, and eventually product_attribute_id fields are stored in every order detail. " As of this, a Product - size A2, A3, A4 of prices Euros P2, P3, P4 - in products csv imports file needs only one entry in csv excel, in other words Only one Product ID? Edited December 20, 2014 by lse123 (see edit history) Link to comment Share on other sites More sharing options...
bellini13 Posted December 20, 2014 Share Posted December 20, 2014 Correct, they are just variations of the same product, so they share the same product id. the product attribute id is used to provide uniqueness Link to comment Share on other sites More sharing options...
lse123 Posted December 20, 2014 Author Share Posted December 20, 2014 (edited) how to price product in case combinations are also priced in csv file import? Print: A2, A3, A4, DL Price $: 130, 90, 60, 40 DL=Download Photo version. Edited December 20, 2014 by lse123 (see edit history) Link to comment Share on other sites More sharing options...
bellini13 Posted December 21, 2014 Share Posted December 21, 2014 The product sets the base price which applies to all combinations (attributes), and then each combination can increase the price by X amount (aka "impact on price") So in your scenario, you can have a base price of 40 (for the DL), and then A2 would be +90, A3 + 50, A4 + 20 etc... Or you can have a base price of 0, and then each combination would have their full price. As for csv files and importing, you should create 2 csv files. 1) Load all the base product information (name, descriptions, price, images etc...) 2) Load all the combination information (attributes, impact on price, combination specific images etc...) You should review the csv file samples in the back office advanced parameters > CSV import page. Link to comment Share on other sites More sharing options...
lse123 Posted December 21, 2014 Author Share Posted December 21, 2014 In such csv 2 files each product in products.csv should correspond in one combination in combinations.csv...? Or in my case in 4 combinations=4 entries in combinations.csv? Product price can be zero but all combinations have price? Link to comment Share on other sites More sharing options...
bellini13 Posted December 22, 2014 Share Posted December 22, 2014 did you bother to look at the CSV samples I pointed you to? Link to comment Share on other sites More sharing options...
lse123 Posted December 22, 2014 Author Share Posted December 22, 2014 (edited) these are depended - meant combinations.csv and products.csv samples are interconnected? Also for a group of similar products can I define a common combination group for all group of products eg in the same category? Edited December 22, 2014 by lse123 (see edit history) Link to comment Share on other sites More sharing options...
bellini13 Posted December 22, 2014 Share Posted December 22, 2014 these are depended - meant combinations.csv and products.csv samples are interconnected? yes. they are interconnected. as i explained, you create a base product in products.csv, each product gets a unique id. then in the combinations.csv you add each of your combinations, referring to the base product id Also for a group of similar products can I define a common combination group for all group of products eg in the same category? give me an example, i'm not sure I understand your question Link to comment Share on other sites More sharing options...
lse123 Posted December 22, 2014 Author Share Posted December 22, 2014 In case sell B&W Photos all Photos have same combinations. so use only one entry in combinations.csv - is possible? Also In An entry in Products CSV File corresponds to only one entry in combinations CSV File... In case all products have 4 combinations(A2,A3,A4,DL) prices? Link to comment Share on other sites More sharing options...
bellini13 Posted December 22, 2014 Share Posted December 22, 2014 I would suggest you play with the csv files and experiment with the import process on a test store. The more you play with it, the better you will understand. Give it a try, and then come back with questions afterwards. Link to comment Share on other sites More sharing options...
lse123 Posted December 22, 2014 Author Share Posted December 22, 2014 I would suggest you play with the csv files and experiment with the import process on a test store. The more you play with it, the better you will understand. Give it a try, and then come back with questions afterwards. 1.6.0.9 One last Q: to submit combinations for given products - needed any manual insert work to add attributes/features or even combinations? I product price may be zero - get price from combination? give text or video Tuts URLs? Link to comment Share on other sites More sharing options...
lse123 Posted December 23, 2014 Author Share Posted December 23, 2014 I must backup database before my very first initial csv product imports? Link to comment Share on other sites More sharing options...
bellini13 Posted December 24, 2014 Share Posted December 24, 2014 Yes, I would always backup the database before you make any changes (you really should have a script creating daily backups anyway). But I would suggest you create a test store and experiment with this before trying to do this on your live store. Link to comment Share on other sites More sharing options...
lse123 Posted December 26, 2014 Author Share Posted December 26, 2014 (edited) 1.6.0.9 One last Q: to submit combinations for given products - needed any manual insert work to add attributes/features or even combinations? Edited December 26, 2014 by lse123 (see edit history) Link to comment Share on other sites More sharing options...
lse123 Posted December 28, 2014 Author Share Posted December 28, 2014 HAVING SET CATEGORIES MANUALLY To insert Products needs two csv files Only combinations.csv & products.csv? Link to comment Share on other sites More sharing options...
lse123 Posted December 28, 2014 Author Share Posted December 28, 2014 (edited) 1. Your .CSV file has been successfully imported into your shop. Don't forget to re-build the products' search index. how rebuild products??? 2. also in products browse , in each product value seem always pre-taxed value... or may seem and taxed value for each product? 3. Products csv import OK shown combinations OK import but not shown in Products... required: Don't forget to re-build the products' search index. how??? Edited December 28, 2014 by lse123 (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts