Adding Product Serial numbers to orders

Hi all,

Is there a way I can record individual product serial numbers to orders such that I can keep records of which exact product has been shipped to the customer for purpose of any future RMA, warranty follow ups?

Currently I'm recording them in a separate excel spreadsheet but I think it's a good feature to be added to the nopcommerce product or maybe it's already available and I'm doing it wrong?

In nopCommerce Admin, you can:

- See all orders by: Sales > Orders
- See individual product purchased with orders by: Catalog > Products > Manage Products > Select a product from list to "Edit" > Select "Purchased with orders" tab

Hope this help :)

ima9ines wrote:

Hi,

I know about those, but how do you add a specific serial number thats unique to each product item in the orders?

For example:

I sell Cars on my my website.

i have 20 cars in my inventory. Each car has a unique serial number.

When I fulfill an order, I would like to tag the customer order to the unique serial number so that if the customer wants to send in the car for "servicing", i can verify that the car was bought from my store.

This is not available out of the box. You will have to do customization work, and I guess it is not that easy since I understand each car  has its own serial model which is attached to some of its attribute combinations (color, sub-model, engine, etc.). I guess you have 2 or more identical cars with the same combinations but each with its own serial number. What I suggest  is to assign an "Basic SKU" to each different attribute combination and then create a table in which you have the serial number assign to its Basic SKU. When you sell a car you check in your table and assign the oldest available serial number which matches with the Basic SKU. This way inventory can also be controlled. I hope I explained myself.

eadameg wrote:

Well, I was going to simplify things by looking at the models for orders and shipping and see if I can add an extra attribute as well as a new column in the DB for me to insert notes..

Are you aware that you can add notes to orders?

I ended up doing a core customization to do this in my scenarios.  Basically, the erp in the backend had serialized inventory.  What I had to do was customize the shopping cart item first to make sure anything that was going to have a serial number could never have a quantity higher than 1...basically, make sure the shopping cart has a all qty 1. Which means if someone buys 2 identical of something... you need 2 line item in your shoppingcartitem table. When the order is placed, you essentially create a 1 to 1 mapping of the order/order item table in nop to your sales order processing table in your erp.  If you don't have an erp, its ok, you accomplish what you need and that is a serial number tied to an item that was ordered. Can't really be done if you have 2 qty for 1 line as you have to uniquely identify them.
From there, add a new attribute to your orderitem table called SerialNumber.  Your ToModel and ToEntty in the current service will be fine once you add the new attribute to your domain class.  Then its just a matter of updating the models and views in administration to support the new field. You would manually place the serial numbers in on order fulfilment by doing the scenario that someone mentioned above (edit order in the backend and editing the product (each line) and placing the serial number in wherever you placed your new textbox, and saving.
Some of what your looking for was already discussed in this thread around controlling specific inventory.  It doesn't look like serialized inventory will be supported anytime soon, so its one of those customizations that will have to be done for each version. Although... depending on how Rental products get implemented, you might get a hook for some type of unique identification for a product. Time will tell on that one.

eadameg wrote:

See...I get words of wisdom from you all the time!!

I will check it out thanks

ChuckR wrote:

Hi Chuck, I will check out the order notes first before I go down this route.

loba wrote:

Sounds good. If your not integrating to an ERP system for SOP like I am, then my method is probably overkill.  Using order notes, you could easily write a report or something along those lines.