[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Odd order number
****** message to minivend-users from Ryan Hertz <rhertz@gyb.baits.com> ******
....without reading all of your response, I just thought of something. If
one access to the mv order.number increments it, thus you are burning two
numbers at each order, perhaps you could use some Perl to grab the contents
of the order.number file?
At 05:35 PM 6/4/99 , Kyle Hayes wrote:
>****** message to minivend-users from Kyle Hayes <khayes@quicknet.net>
******
>
>
>
>On Fri, 4 Jun 1999, Ryan Hertz wrote:
>
>> At 11:40 AM 6/4/99 , Kyle Hayes wrote:
>> >1) the variable mv_order_number is blank. If I place the line:
>> > &set=mv_order_num [value mv_order_num]
>> >in the code, then I get a valid number (000016 for instance).
>>
>> Where do you make this set? I couldn't find code like this in any of my
>> checkout/report/receipt pages... Can you determine, by looking at
>> /your/loc/to/mvend/sample/etc/order.number if that causes the number to
>> increment?
>
>I make it in the checkout profile in checkout.html. It is a hack :-)
>But, it seemed to do the job. Within a [sql] block, it is almost as if
>certain state is not visible. I have had no luck at all with scratch
>variables being used within SQL:
>
>[sql type=set base=orders interpolate=1]
> INSERT INTO orders (order_code, payment_auth)
> VALUES ('[value mv_order_number]','[scratch payment_auth]')
>[/sql]
>
>This seems to set the second argument to "" if the scratch variable is
>defined within the checkout profile block. If I don't do the
> &set=mv_order_number [value mv_order_number]
>call before the SQL, then [value mv_order_number] seems to come back
>empty.
>
>> >2) The order number that prints on the receipt report is not the same
>> >as the number that is inserted into the database. It is exactly one
>> >more. For instance, if the order is placed in the database with order
>> >number 000016, then the receipt says 000017.
>>
>> I think the problem is that the order number is magic. If you touch it
>> before the order is complete, it increments - you should put your db insert
>> on the receipt or report page... but, if the db becomes +1 of the receipt,
>> it's not my fault. ;-)
>
>This is what I was wondering. This is going to make my life difficult.
>Due to other constraints, I need to store the pending order _before_ the
>credit card authorization. If I don't, there is a chance (small, but not
>zero) that I will charge the credit card without placing and order for
>fulfillment. That is not acceptable :-(
>
>Our customers can order through our web site in two ways. The first is
>via credit card (which now looks like it might take a two-level ordering
>scheme) and the second is via FAX. They do the order online, but get a
>page at the end that they must fax along with a copy of their credit card
>to us.
>
>Is there a way to have one submit button take customers to the credit card
>page and another straight to the end report page? In looking at the
>recently posted example of a two-level check out system, it looks like it
>could be done...
>
>> >Any ideas? The odd blank value is disturbing. The fact that the
>> >receipt has a different order number than the value used in the check
>> >out profile in checkout.html is weird too.
>>
>> It must be blank because you're pulling it too soon... my guess.
>
>Hmm, unfortunately that makes it a tad difficult to do what I wanted. I
>think there is a work around with a two level checkout page, but that
>isn't exactly what I wanted.
>
>Best,
>Kyle
>
>
>
>-
>To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
Ryan Hertz tel 520-645-3812
Webmaster tel 800-645-BAIT
Advertising Director fax 520-645-2588
Gary Yamamoto Custom Baits, Inc. http://www.yamamoto.baits.com
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
