Guest Posted January 21, 2007 Posted January 21, 2007 Hi I sell my products in OSC and at local markets. I would like to to enter the market sales into OSC and get a report of the products purchased at markets. I set up a user with the name of Market Sales, but can only get the total sales, not the actual products sold. Searched forums, contributions, (even googles) without success. Can anyone assist?
Guest Posted January 29, 2007 Posted January 29, 2007 Hi I sell my products in OSC and at local markets. I would like to to enter the market sales into OSC and get a report of the products purchased at markets. I set up a user with the name of Market Sales, but can only get the total sales, not the actual products sold. Searched forums, contributions, (even googles) without success. Can anyone assist? Guess not.
Guest Posted March 1, 2007 Posted March 1, 2007 can you explain a bit how your structure for the local market is with osc? Do you base this info from the delivery address, customer groups how this is structured? If its with zones for instance you could parse the orders_products and orders tables and group them using the deliver_country, delivery_state or delivery_postcode. And then get the totals by zone and display the products shipped there.
satish Posted March 1, 2007 Posted March 1, 2007 manual order editor. Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does.
Guest Posted October 23, 2007 Posted October 23, 2007 can you explain a bit how your structure for the local market is with osc? Do you base this info from the delivery address, customer groups how this is structured? If its with zones for instance you could parse the orders_products and orders tables and group them using the deliver_country, delivery_state or delivery_postcode. And then get the totals by zone and display the products shipped there. Hi Mark Missed your post. Sorry, what I mean is to pack goods up and physically sell them on the spot at markets around Melbourne. The situation is this: Go to market to sell product. Record products sold as they are sold. Enter data into OSC on return to home/office into PC. There are various markets that we go to, so it would be nice to get an individual report per market, as well as for preceding (say) year. This way, we could determine which markets and which times of year are best. It would also be nice to get an overall view of market sales over a period of time. This way, we could see that x sells best here at this time of year, y sell best there at that time of year. Market prices are different because of different overheads. Also thinking of party plans, so it would be nice to do the same for them, as well as for "over the counter" sales.
♥toyicebear Posted October 23, 2007 Posted October 23, 2007 Hi Mark Missed your post. Sorry, what I mean is to pack goods up and physically sell them on the spot at markets around Melbourne. The situation is this: Go to market to sell product. Record products sold as they are sold. Enter data into OSC on return to home/office into PC. There are various markets that we go to, so it would be nice to get an individual report per market, as well as for preceding (say) year. This way, we could determine which markets and which times of year are best. It would also be nice to get an overall view of market sales over a period of time. This way, we could see that x sells best here at this time of year, y sell best there at that time of year. Market prices are different because of different overheads. Also thinking of party plans, so it would be nice to do the same for them, as well as for "over the counter" sales. There is a customer vs products orderered report available in the contribs section Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here]
Guest Posted October 23, 2007 Posted October 23, 2007 There is a customer vs products orderered report available in the contribs section Thanks Nick for the reply. It is not what I require.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.