Product ID/SKU Unique Question

[mike_latzky]

A site requirement is that every product we will have will be one-of-a-kind. Therefore, every Product ID, every SKU, will need to be a unique value. In addition, our clients will be submitting inventory for our approval before listing it for the "public" to see It and have it available for purchase.

Think of this as a consignment store type of idea on a larger scale.

Some issues I'm facing and not sure how to solve are:

1. How to ensure uniqueness and assigned Product ID/SKU

2. Role/access rights of a user to add an inventory item for approval by an "approver" role who is a staff person

I'll have others as I think through the requirement process such as: once the item is approved for "sale", the item is then available for customers to see under the appropriate categories. This seems fairly easy, but I'll need to think through the categories, etc. and the other aspects of "transfer" of status, and what happens to paying the original owner for their share, etc.

But at this point, the two questions above are my most pressing concern. I can see the potential for QR code and/or Bar Code technology to improve the reliability of stocking and shipping and have made inquiries on this part of the process.

Thanks in advance!

[Vimal Kumar]

Hi @mike_latzky,

As per your requirement. 

 

1. How to ensure uniqueness and assigned Product ID/SKU
VP:  Product Id and Product sku are always unique in the magento. You can't create any product using same product sku. Product id is auto generated for each product. It is primary key of the product table. 

2. Role/access rights of a user to add an inventory item for approval by an "approver" role who is a staff person
VP:  As I mentioned in your another post. You can't set permission at Product attriute level. You can mange at Product grid level. 

But you can mange this approval thing using some customizations.
You can create a custom admin grid with "Id, SKU, Qty, Approvel Status". 
You can make enteries in this grid, and you can also assign Admin user role for this Grid only. As any approval persion, approve the inventory then you can update the particular product using Magento 2 REST Api using product SKU. 

This can solve your problem with Approval and Permission as well. 

This is my basic solution, you can think more and extend or any good idea can be implement. 
===

Your another question.

You can assign a product into any category. 

For QR code and Bar code, some extensions are available at marketplace. 

I hope it will help you!

[mike_latzky]

Thanks for your help here @Vimal Kumar - I'll look through this and work on the details as you suggest to see how this can fit.

[mike_latzky]

Having started into the reading through of this, I'm not sure where to find either an example or an understanding of where to proceed on this.

I've looked through the Magento docs and the forum, and run a few searches and haven't found anything that was clear on a direction that spells out how to proceed.

Can anyone suggest a clear path and the steps to do this?