Author Thomas Huulbaek Andersen on 11-09-2000 at 04:20 (EST)
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.
Direct Computer Supplies
|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:
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:
Billing Last Name
Billing First Name
Billing Company Name
Billing Customer ID
Billing Street Address
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:
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:
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.
| 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??
| 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).|