uShop English (U.S.) for 179!

uStorekeeper English (U.S.) for 149!

 Products
       uTest
       uReserve
       uShop
       uStorekeeper
       uGolf
       uDirectory
       uSignIn
 Tech Support
       Support Policy
       Knowledge Base
            uTest
            uReserve
            uShop
            uStorekeeper
            uGolf
            uDirectory
            uSignIn
       Documentation
       Reference Sites
 Legal
       Software Piracy
       Legal Notices
       Privacy Policy
       Licensing
 Miscellaneous
       Reseller Info
       Contact Us
       Site Map
Order Processing

Knowledge Base Lobby : uShop Support Conference : Programmer Tips
Nov-22-17 09:53 AM EST
Original Message
Order Processing
Author Thomas Huulbaek Andersen on 11-09-2000 at 04:20 (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
E-MAIL AUTHOR | TABLE OF CONTENTS

Table Of Contents
  RE: Order Processing Bill Weiner, 2000-11-09 06:03:15 (1)
            Thanks ;) Thomas Huulbaek Andersen, 2000-11-09 06:52:58 (2)
                 RE: Thanks ;) Bill Weiner, 2000-11-09 07:55:50 (3)

Messages In This Discussion
         1. RE: Order Processing
        Author Bill Weiner on 11-09-2000 at 06:03 (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.
TABLE OF CONTENTS
                 2. Thanks ;)
                Author Thomas Huulbaek Andersen on 11-09-2000 at 06:52 (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
TABLE OF CONTENTS
                         3. RE: Thanks ;)
                        Author Bill Weiner on 11-09-2000 at 07:55 (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).
TABLE OF CONTENTS

© 2003 Microburst Technologies, Inc.