Prestashop. Make Orders to show SKU Number

[uyuco9]

Hi,

We have an online business where SKU's are very important. I would like to have the SKU shown on the orders page. i.e. when you click the orders tab, I would like to see the list of orders with SKU's.

Can anybody assist me with this issue? Your collaboration is very appreciated.

Regards

UYUCO

[uyuco9]

Please somebody help

[rocky]

Which field is your SKU number stored in? Is it per-order or per-product? Is it in the reference field of the product?

[uyuco9]

Thank you for your reply,

I just set up the store. We will sell cosmetics. We need that the list of purchases contain the SKU which we can store in any field, as long as it can be shown on the order lists,

SKU is a very important part when pulling items from our warehouse to the shipping department,

I hope I responded to your questions, and I thank you again for your time and cooperation. I am looking forward to hearing from you!

UYUCO

[rocky]

I still don't understand. If an order has two different products in it, will it have one SKU or two SKUs?

[uyuco9]

Each product will have its own SKU

[rocky]

That would be difficult to do. It is easy to add another column from the order, but to combine fields from products inside the order and then display them as an order column would be difficult. I'm not sure how to do it. It would look weird too when there are many products in the order. The column would be too wide.

[uyuco9]

how can I add a column on the order? What we would need is something like the ebay backend where each sku (custom label) is shown on orders.

[rocky]

To add a new column on the Orders tab, edit the $fieldsDisplay variable in admin/tabs/AdminOrders.php. You can add a new item to the array with the field name in the ps_orders table as the index. Unfortunately, you can't choose a field name from the ps_product table. You can specify many things including the title you want for the column, the width of the column, the alignment of the column, the type of the column and whether a filter can be applied to the column. I see now that there is also a callback option (like used on the id_pdf column). Perhaps you could use that to write a function that gets the reference field of the products and combines them.

[uyuco9]

Thank you. I will try to follow your instructions. Please let me know if you know any "pre-made" module or fix that can solve what I need.

Thank you for your time. I will ask more questions soon. I appreciate it.

UYUCO

[pepekmentul]

To add a new column on the Orders tab, edit the $fieldsDisplay variable in admin/tabs/AdminOrders.php. You can add a new item to the array with the field name in the ps_orders table as the index. Unfortunately, you can't choose a field name from the ps_product table. You can specify many things including the title you want for the column, the width of the column, the alignment of the column, the type of the column and whether a filter can be applied to the column. I see now that there is also a callback option (like used on the id_pdf column). Perhaps you could use that to write a function that gets the reference field of the products and combines them.

yes sku is very important, especially for website with lots of products. my first online store is made with jo*mla and the sku is included automatically in the order form. now with prestashop, this very basic need gets really hard. as we all know, sku is unique product code that differs one product to another. it's the very basic thing for ecommerce store to have. the fact that our beloved prestashop doesnt have it is an unforgiven sin. but i still love prestashop tho. well it's just my opinion. rocky you're great

[Gehnaonline.com]

Yes you can ADD SKU by Creating Features -
Add SKU as one of the Features and add your SKU numbers in Add feature value. Its so simple.

Each time you create item listing you have to just select SKU number (If you already entered it into feature value) otherwise enter it manually.

And call that feature value field (table) into order.tpl
A simple thing any developer can do it for you.

[mariamarcella]

Automatically generate code sku PrestaShop

 

where can i do this?

 

please help

 

txs lilian