Hi,

Can you tell me what the mechanism is for customers to be able to see their serial numbers?

When we get the email sent, there is no serial number there. This is a DOWNLOAD product, so the download link is correctly there.

The StoreOrderDetails table DOES have the serial number in it, followed by a comma (I guess to prepare for multiple serials). But it is not in the email the customer gets. In the email you get (see the UPPER caps):

Product Name

Quantity

Unit Cost

Download

THE PRODUCT IS HERE WITH NO SERIAL                                             OK                  OK                   OK

Also, the serial is not listed when viewing the order from the customer menu.

Is the serial supposed to be added to the ProductName field in the table? Or is the serial number supposed to be part of a query when customers read their orders in the Account area?

Thanks for any help! Maybe there is a stored procedure that did not get updated or something... both when the email is supposed to go out and when customers view their order history.

On the Manage Order Details page for the order, there is a tab called Custom Fields and File Uploads/SN but all are empty.

You mention "Custom Attributes" tab... is there a tab missing in my cart? I have the Shipping/Billing/User info tabs, and the Custom Fields and File Uploads/SN tabs.

The table with the product data is: Sku, Product Name, Qty, Unit Cost, Line Total and no serial there.

Plus, there is no serial listed in the customer email. Even when viewing a test order in my account there is so serial displayed anywhere. The only way I can see the serial number is to go to the edit product page and view the list of serial numbers and see the order number there.

The customer DID say that he got the serial however, so maybe it did appear on the checkout page after a purchase.

Something is preventing any indication of a serial from showing in emails, in customer receipts, order reports, etc. after the sale. Only by digging into lists or tables can I get the customer the serial number. As mentioned the serial is in the StoreOrderDetails table, and of course the ProductSerials table has been updated with the order number.

So something is not connecting all this when the email is sent, or when the admin or customer is trying to view the orders. It must come down to one or two modules or stored procedures somewhere that is not connecting it all.

UPDATE: I ran another test order. Here are the results:

Serial number is visible on the Confirm Status page. In the Product Name box in the table you get PRODUCT_NAME, Serial Number = ABC,

The customer email has no serial number. Just the product name.

You cannot view any serial numbers in the Order Details page, in any area.

Hope this helps! Of course we need to have the customer get their serial number in more than just the checkout confirm page, as they will not likely always write that down.

5.30 and DNN 7.02

I did not apply the latest update yet as I did not see any fix notes about this.

If I need to manually reinstall some modules or something maybe you can tell me which ones.

I looked through all the sql provider files for "Serial" and I did not see where it is determined what to display to the customer. It shows Select * so maybe this is at the module level.

Hi Steve,
In your BuyNow settings "Gift Certificates & Serial Numbers" section can you confirm that you have selected the radiobutton option titled "Product Serial Numbers - Assign from List"

Thanks,

---

Scott Kelly
Project Manager

Hi Steve,

We have resolved this issue and the fix will be available in the next release of the Cart.

Thanks for reporting the issue!