am looking to set up zen cart for a business i work at. front end for users is looking good. admin report for sending to our supplier looks like it will work with 'sales report' add on.

here's the scenario i'm looking at.

x number of Buying Clubs order through us. we buy from a single supplier and receive all the product at once. we need to separate the orders (which Club gets what) as we check the product in.

here's the scenario:

1. pull cases from pallet and match case product number from check-in sheet.
2. check-in sheet will list each product number and how many for each Club.
#123456 - grape jelly - 2cs - Buying Club A - 1cs - week A
Buying Club B - 1cs - week B
....and so on
what i need on the report is product (model) number, product name, total qty ordered(optional?), last name (Buying Club name), qty per Club, week number (company name).

i use the 'add customers from admin' add on to add the customers and would need to use those fields for the report.

is there anything like this out there?

can someone create this for a reasonable price? in a short time frame?

i am so grateful for all you contributors who have the skills to do all this stuff! without you, open source wouldn't exist.

thanks for any help.