bruce-rez Posted February 9, 2011 Share Posted February 9, 2011 Hi,I need to create a database with combination. I know how to make a simple database in Excel but what I need to know is, creating for example; a column for Color with 48 attributes(48 different colors), Quantity(5-50)?How can I create this kind of database in Excel for that I can import it as csv file in Prestashop?I hope this makes sense.Thank you in advance fro any help or info. Link to comment Share on other sites More sharing options...
bruce-rez Posted February 10, 2011 Author Share Posted February 10, 2011 I would appreciate it if anyone can guide me how to do it or I would be grateful if you know any friendly database software for this kind of work.Thank you. Link to comment Share on other sites More sharing options...
PrestaMagic Posted February 10, 2011 Share Posted February 10, 2011 Hi Bruce,We just did this for our very complex implementation. It takes programming work to make all those permutations - it's not a case of the database, but rather, what you put into the database. There is no "friendly database software" to create that data for you.I would suggest hiring someone off Elance or such to create those permutations for you in whatever database you are using to run the shop from.Sorry that I did not have a quick and easy answer on this one. Link to comment Share on other sites More sharing options...
bruce-rez Posted February 10, 2011 Author Share Posted February 10, 2011 Hi jayzee,Thanks for the reply.I need only minimum guidance in how to make a column for only one item in Excel and I can finish it myself. For example I have an item with different color. I need to know in Excel if I create a column for Color name ,how and where to insert the Red,Blue,Green,Yellow, etc. That's it. Link to comment Share on other sites More sharing options...
nuclearholocausto Posted February 12, 2011 Share Posted February 12, 2011 The way the table would be depends on how will you be using the data. Which data will be changing, (i.e. are the colors constant? or is it the quantity that will be constant? Link to comment Share on other sites More sharing options...
bruce-rez Posted February 12, 2011 Author Share Posted February 12, 2011 Hi nuclearholocausto, Which data will be changing, (i.e. are the colors constant? or is it the quantity that will be constant? Color will be changing and it is not impacting the price. But for each item there are many colors, between 10 to 50 color options.Other things that I need to include in the csv file are:Size, Minimum Quantity and Price.If Quantity is between 5-50, Price (per unit) is $5.50If Quantity 51+, Price (per unit) is $3.75Please see the screen shot.Thanks. Link to comment Share on other sites More sharing options...
nuclearholocausto Posted February 12, 2011 Share Posted February 12, 2011 What would be the price be if the quantity is less than 5? Will it still be 5.5? Link to comment Share on other sites More sharing options...
bruce-rez Posted February 12, 2011 Author Share Posted February 12, 2011 What would be the price be if the quantity is less than 5? Will it still be 5.5? The Minimum Quantity is 5 in order for it to be processed. That means if the minimum quantity is less than 5 the order is not precessed.Thanks. Link to comment Share on other sites More sharing options...
Kelvin Koh Posted February 16, 2011 Share Posted February 16, 2011 Hi nuclearholocausto,Which data will be changing, (i.e. are the colors constant? or is it the quantity that will be constant? Color will be changing and it is not impacting the price. But for each item there are many colors, between 10 to 50 color options.Other things that I need to include in the csv file are:Size, Minimum Quantity and Price.If Quantity is between 5-50, Price (per unit) is $5.50If Quantity 51+, Price (per unit) is $3.75Please see the screen shot.Thanks. Hi Bruce, the solution to your issue is very simple. You only need to create an Excel and csv file each for (1) Products and (2) Product Combinations.For Products, create the following columns: Product ID, Cat ID, Name, Wholesale Price, Price, Image URLsFor Combinations, create the following colums: Product ID, Color, QuantityFor your specific case, price impact by Color = 0, so you can safely ignore the price impact and set Price = $5.50 in your Products Excel & csv files.After you have imported all Products and Combinations, configure all your product's bulk price discounts.In your BO Products page, go to Prices tab and Add a new specific price. Set Starting at XXX unit to 51, Product price to $3.75.I'm not sure your Minimum Quantity has to be 5 for EACH color or a total of 5 for any/all colors (i.e 3 Red + 2 Blue), so I'm unable to give specific action. If you want a Minimum Quantity of 5 for EACH color, you can go to individual combinations to set it.You're done! Now test it to see if it works the way you want. Link to comment Share on other sites More sharing options...
bruce-rez Posted February 17, 2011 Author Share Posted February 17, 2011 First thank you for your detailed explanation.As you mentioned I created 2 csv files for Products and Combination. Then I imported both files in BO with success. I am testing only with one product for now but I will have about 400 items to import later when I learn correctly this process.I know how to import the products with success, this is ok for me. I imported the csv Combination and I can see the attributes in the Products > Combination but I do not see them in Front Office.So I need some guidance in BO >Products > Combination page.Q1: What should I set up at this step in BO >Products > Combination page? After you have imported all Products and Combinations, configure all your product’s bulk price discounts.In your BO Products page, go to Prices tab and Add a new specific price.Set Starting at XXX unit to 51, Product price to $3.75. I figured it out. it works and shows up in FO.Q2: How can I add Size and Minimum Quantity attributes in the same Combination csv file and how to match them with Prestashop Field? I’m not sure your Minimum Quantity has to be 5 for EACH color or a total of 5 for any/all colors (i.e 3 Red + 2 Blue), so I’m unable to give specific action. If you want a Minimum Quantity of 5 for EACH color, you can go to individual combinations to set it. Minimum quantity is constant and it stays the same whatever the color or size.Thank you. Link to comment Share on other sites More sharing options...
bruce-rez Posted February 20, 2011 Author Share Posted February 20, 2011 I am still waiting for a solution or answer to my problem.Thank you in advance. Link to comment Share on other sites More sharing options...
bruce-rez Posted March 1, 2011 Author Share Posted March 1, 2011 I am still waiting for any help.I want to make a separate CSV file for Combination with the below attributes:SizeColorMinimum QuantityQuestion:How to match these attributes with the Prestashop Required Filed ?I do not see any attributes in Prestashop that can mach with Size, Color and Minimum Quantity.I would appreciate any advice or help. Link to comment Share on other sites More sharing options...
bector Posted September 7, 2012 Share Posted September 7, 2012 (edited) hi , i want to generate combination with different quantity for eg , i have T-shirt in RED, GREEN ,BLUE, where RED have size 26, 28 30 and green have 30,32,33 and Blue have 44,46 and each coloar+size have different quantity. ie RED->26-> have 5 in stock RED->28->have 6 in stock RED->30-> have 10 in stock same for green and blue any easy way to add this type of entries in pristashop any help Edited September 7, 2012 by bector (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now