There are many such solutions out there... I have built many myself.
Products like clothing often have a standard range of colour, size and perhaps style.
Products such as computers will have options such as memory and hard disks and accessories.
Other products such as shelving systems will have companion products eg. for each shelf there might need to be 18 screws and 4 glass panels.
The issue, eagles56, is whether the system you are looking for... that specifically suits your purpose has been built and is available...
You will need to tell us more about your requirements to answer that.
Thanks for you reply Lynsay.
Actually I'm dealing with Gift and Premium products like Lanyards and Key chains. All the products are unique and have many different options which are not similar from one product to the other as you can see on the pix attached. Prices are related to the qty increase as well.
i have just comleted John Mark Osborne's tutorials on VTC but I can see no direction to how to design it with filemaker and have it integrated on the Invoice portal.
Any help would be very much appreciated
Alex - Bangkok
It would very cool if anyone can point me out to some "already made solutions" or codes for that matter. It appears as if code for filemaker is impossible to find. I haven't had this kind of problems with other language like php for example!!
Can you send me a better photo I can't get a complete picture of your problem, but may be able to with a better starting point.
Thanks for your message Olda.
Please find herewith attached some of the products I'm dealing with. It's french writing but you'll get the idea. Prices are related to customers and each product has his own set of options. When quoting or invoicing I need to find the product and his options in a snap of second.Quotes needs to be transformed into invoices if the customers deal with us.
Thanks for your reply
Date: Sun, 3 Mar 2013 16:20:14 -0800
Subject: Re: Invoice solution with a list of products with many options
created by oldal41 in FileMaker Product Management Q&A Topic Suggestions - View the full discussion
Can you send me a better photo I can't get a complete picture of your problem, but may be able to with a better starting point. oldal
Reply to this message by replying to this email -or- go to the message on FileMaker Technical Network
Start a new discussion in FileMaker Product Management Q&A Topic Suggestions by email or at FileMaker Technical Network
Manage your email preferences.
FileMaker Developer Conference 2013 • San Diego, California • August 12-15 • www.filemaker.com/devcon
specialinquiry.zip 153.3 K
Sent from my iPad
Olda, I can see it on my ipad down the page on this discussion thread as specialinquiry.zip . Do you have an email address to which I can forward it to you?
1 of 1 people found this helpful
Invoices is one table. A related table will be the Invoice Transactions. Each Transaction will probably pull from some Inventory table that has a full description of the item. You will have a related Rolodex or Client table. And then there will be a table for pricing based on who the client is and the volume purchased per item or other such discount arrangements. While most of these have similarities, the main reason for using FileMaker is the ability to customize the database to the clients needs.
You might want to check out the "Made for FileMaker" solutions at http://solutions.filemaker.com/made-for-filemaker/
Or you can look up a FM developer in your area if you want some help locally: http://developer.filemaker.com/search/
See attached DF and Excel files.
Thank you very much for your insight and time Oldal.
if I understand you well you've created as much as product_ids as there are products and options. right? when a product is combined with 2 or 3 options the product_id creation is exponentiel.
This is what I've tried to do at the beginning but it's a cumbersome task as I have to deal with 100 products of which each of them has their own options.
Besides prices varies with quantities as shown below:
500≤quantity and quantity<1000; PRODUCTS::price1;
1000≤quantity and quantity<2500; PRODUCTS::price2;
2500≤quantity and quantity<5000; PRODUCTS::price3;
5000≤quantity and quantity<10000; PRODUCTS::price4;
I'm a newbie in Filemaker. It's difficult to see the real logic behind it.
Let us know what solution you used. Thank you.
I've followed your recommendation regarding the structure of the tables Invoices -> LineItems <- Products
Options are entered in the Products table independently to their product they are attached to.
I've added a category field on each Product records which I filter out on the Invoice portal using a Products_Occurence table linked to Invoices table.
A popup list on the Invoice layout allows a product "xyz" to be chosen along with all his options related to that category.
The price field on the Invoice portal is a calculation field which pulls the data from the Products table related to the quantity as I mentioned above case(...)
In your example above:
Is product_id's for Option 1 Option #1.1 etc... entered in the product table? How do you make them appear in the column1 in the layout?