www.uburst.com www.uburst.com

"Order Processing"

Go back to the LobbyClick here to Go Back to Main ListingClick here to see helpClick here to Search the Forum

Programmer Tips
Forum Type: Public
Moderator: edmunds
Time Zone: EST
Printer Friendly Format
Original Message
 
"Order Processing"
Posted by Thomas Huulbaek Andersen on Nov-09-00 at 04:20 AM (EST)
Hi All,

Since integrating uShop with our Concorde C5 system (via ODBC/SQL) I want to take the last step and go full-automatic. I need to automatically write the orders in the system. So... I guess the easiest way would be if the orders came in a (for instance) comma-file. Is there ANY way to do this?

Thanks in advance.

Sincerely,

Thomas Andersen,

Direct Computer Supplies

Click to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents

 Table of Contents

RE: Order Processing, Bill Weiner, Nov-09-00, (1)
Thanks ;), Thomas Huulbaek Andersen, Nov-09-00, (2)
RE: Thanks ;), Bill Weiner, Nov-09-00, (3)

 

 
Click here to goto Click here to goto the Lobby
Messages in this discussion
 
1 . "RE: Order Processing"
Posted by Bill Weiner on Nov-09-00 at 06:03 AM (EST)
For version 3.x, here are a couple options that you may be able to work with:

1) Check out Section 11.1.6 in the User's Guide:

http://www.uburst.com/uShop/reference/users_guide.html

If you turn the "Maintain Customer Log" option "ON"... then for every order, the following information will be written to the "ushop-customers.log" file:

Order Number
Order Date
Subtotal
Total
Billing Last Name
Billing First Name
Billing Company Name
Billing Customer ID
Billing Street Address
Billing City
Billing State
Billing Zip
Billing Country
Billing Phone
Billing Fax
Billing Email
Billing URL

This may be an easy way for you to get the information about the customer.

2) Check out Section 11.1.6 in the User's Guide:

http://www.uburst.com/uShop/reference/users_guide.html

If you turn the "Maintain Inventory Log" option "ON"... then for every item ordered, the following information will be written to the "ushop-inventory.log" file:

Order Number
Order Date
Product ID
Product Name
Product Quantity
Product Price

This may be an easy way for you to get the information about the items ordered.

3) Otherwise, if you need to access all of the order information, take a look at the "read_order_file" subroutine that is located in the "ushop.pl" file (do a search on "sub read_order_file" to get to the start of that subroutine). You will see how that subroutine reads each data element from the order file.... one from each line (about 131 lines total). The field names should be self-explanitory.

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
2 . "Thanks ;)"
Posted by Thomas Huulbaek Andersen on Nov-09-00 at 06:52 AM (EST)
Thanks for the ultra-quick reply Bill. I can see the solution is certainly doable.

One last question: Could the same ordernumber turn up sometime year 2010 or something??

Regards,

Thomas

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
3 . "RE: Thanks ;)"
Posted by Bill Weiner on Nov-09-00 at 07:55 AM (EST)
Because the order number is randomly generated, then technically yes, the same order number could occur more than once... but it is highly unlikely. I believe we do check for the existance of an order file with the same order number.... but that only works until the order file is deleted from the server (which you should do every so often after reading them with the Order Reader utility).
Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents


Archive This Thread: Admin and Moderator OnlyRemove This Thread: Admin and Moderator Only
Click here to goto Click here to goto the Lobby

 

 

 

 

 

 

 

 

 

 

 

 
Questions or problems regarding this bulletin board should be directed to Webmaster
©1997-1999 by DCScripts. All rights reserved.