Open Source Order Management

[C12H22O11]

I am thinking about writing an order management module for the open source version. Below is a list of product attributes that I have come up with. Please let me know if something is missing.

• Product Code / Model
• General Attributes

o Detailed Description
o MSRP
o On Hand
o On Hold & Back Order
o Expected Delivery Date
o Manufacturer
o Category
o Product Shipping Weight
o Drop Ship Only / In stock
o Product Picture
o Tax Category
o Special Shipping Charge
o Is Bundle
o Product Average Cost

• Call Center

o Short Description
o Sell Price
o On Hand
o On Order
o Manufacturer
o Category

• Internet

o Internet Title
o Detailed Description
o MAP Sell Price
o Product URL

• Purchasing

o Vendor Name
o Vendor Part Number
o On Order
o Product Cost
o Last Date In
o Down to (Minimum Quantity)
o Reorder Quantity

• Bundles

o Bundle Part List
o Bundle Part Quantity in Bundle
o Bundle Part Special Price

• Serial Number List

[casibbald]

Shipping must be calculated as volumetric wight.

L x W x H / 6000

if this is greater than the phisical weight shipping companies use the volumentric weight.

This is very important, for future integration with a shop and or shipping system like DHL or UPS

[lmewshaw]

Consider using PHPshop's db structure for products so that you get integration to ecommerce
Install phpshop on a mambo site and take a look at the product db structure that it creates.

[gesota]

Also consider to study the structure of OS Commerce http://www.oscommerce.com. Check out that most of the things mentioned here are already placed in there !

Regards.

[cstude]

I am looking ot download sugar my company has been looking at several apps, netsuite, Micrsoft Great PLains with CRM, etc... First they all cost a bundle, Second i like the open source community but it seems like most of the crm products are just that they are not bulndled or suites like the above mentioned. We run a ecommerce site as well as do telemarketing, take phone orders, fax orders, need AR, AP, GL features, Vendor and Partner management, shipping integration, etc... can any one help me

[kenlyle]

We are using OSCommerce (OSCMax) and Mambo. I am hoping that MOSCommerce or other Mambo/OSC integration matures.

As for integrating Sugar with a shopping cart, my thought was that Sugar only seems to know about PRODUCTS, not ORDERS, which would be more useful. There seems to be a table missing in the database. I was thinking, as a workaround, of importing my Orders from OSCommerce as Products, just to give me something to link to if I wanted to drill down, and leaving the bulk of the data in OSCommerce, where it 'belongs'. I was hoping that having the Orders in Sugar would allow me to build groups like Bronze, Silver, Gold, based on the total value of the Orders, and email/contact accordingly.

Anyway, if anyone works on Sugar/Cart integration, my two cents is that MamboPHPShop is managed by one guy who seems overworked, whereas OSCommerce and variants seem to be much more widely supported.

Thanks for the interesting dialog.

Ken

[barrybert]

if this is greater than the phisical weight shipping companies use the volumentric weight.

[anna575]

Hey, This is the nice thread. There are a lot of products which is very important and good for your future. I also checked your site, it's really great and helpful. Great products... Thanks for the nice information.