osCommerce / osCommerce-V4

Other
38 stars 26 forks source link

Product identifiers, Model/SKU is "mixed up"? Missing MPN #42

Closed oewean closed 1 year ago

oewean commented 1 year ago

Just started to test and learning osCV4 and in products there is different product identifiers.

I think Model/SKU is "mixed up"

My thoughts about this is: SKU: Stock keeping Unit is different from business to business, linked to a MPN, EAN etc. A SKU is a seller-defined identifier. As it's used now, it's more like a Model / MPN (Manufacturer part number), A MPN is a manufacturer-defined identifier.

Orders, invoices, packing list, import etc. should use SKU as primary identifier, as this is the normal for warehouses to use to identify products.

I can rename this to SKU and use it as SKU, but it's good to be consistent.

The linked / structured data (application/ld+json) Report this as SKU, for example with use with Google.

Import / export use this as "Products Model"

I think it's important to have MPN as well (for use with linked / structured data, shoppingfeed etc), so MPN should be added as a product identifier.

oewean commented 1 year ago

Any comments / updates on this?

pan-oscom commented 1 year ago

You are right, SKU is different from business to business. Model/SKU field is SKU for your business and you can rename it as you want. If you also want to use MPN, you can: 1) rename one of unused fields ASIN, EAN, UPC 2) use product property 3) write extension and add new field

I suggest you use our forum for such questions. You will receive an answer faster.

jessicana commented 1 year ago

I think there is a bug with the Product identifiers. When all the identifiers are empty, I still can see the model field on the product listing page although it is empty. Suppose I don't want to assign a Model (SKU). Below is the backend with all the identifiers empty:

image

The front end appears as follows: image

The model is there but technically it should disappear because the field is empty.

Let's try and fill in all the fields and see how they appear on the product listing:

image

The front end appears as follows: image

Note that the ASIN doesn't appear on the front end although it is filled. Technically, the ASIN should've appeared in this scenario and the Model (SKU) should've disappeared in the first scenario when it was empty.

Is this a bug or do I have to adjust something in the settings?

You can ignore the product details because that is coming from the properties.

image

pan-oscom commented 1 year ago

Please use our forum for non-programing questions.

The model is there but technically it should disappear because the field is empty. Not really. Some of our clients would like to show the model field even with an empty value.

Note that the ASIN doesn't appear on the front end although it is filled. Technically, the ASIN should've appeared in this scenario and the Model (SKU) should've disappeared in the first scenario when it was empty. Is this a bug or do I have to adjust something in the settings? No. it's not a bug. It's just that there hasn't been a request to show ASIN on the frontend yet.

Actually, you can customize showing these fields in Theme designer: image

For example, there is two choice for Show Model option: Yes and No. But we could add the third option: "Yes, if not empty"

jessicana commented 1 year ago

That is correct. Thanks. But as per the below, the ASIN is not in the properties. How can I add it? @pan-oscom This is my last question and I will post in the forums going forward about this topic.

image

pan-oscom commented 1 year ago

It will be added in the next version of osCommerce