Lee_L

Mark what I find interesting is a SKU can be ANYTHING you want it to be. But a UPC/EAN is unique and can not be changed. I see a number of distributors take the manufacturers SKU and add their own designation to it which means it is worthless for matching a product from multiple distributors.

My site pulls near real time inventory from 5 distributors. At least 3 or 4 carry the same product but my site uses an automated plugin that keeps track of inventory from each distributor.

SKU is worthless as a way to match product and inventory quantity because.

Look at something like the photo industry.
B&H photo, Adorama, Amazon & Ace Photo all carry the exact same Nikon D500.
But B&H’s sku is NID500, Adorama INKD500, Amazon B01A7Q0J3Y and AcePhoto is ACE52274.

But if you put the UPC into any of these sites you get the same product because it is the only unique code assigned to each product.

In some industries such as cosmetics and anything FDA related require a UPC by law.

fran that might be fine for your shop but for those of us who have tens of thousands of products supplied from a half a dozen distributors with different SKU’s for the same product, ONE extra field is not considered overhead.

Every major product produced now days has a UPC or EAN number. In fact you can not even list a product on Amazon (which accounts for 46% of ecommerce) REQUIRES a UPC.

Many of us have found using custom fields as a way to solve this problem. But I think what some find odd is how can Woocommerce not include this as a basic feature.

I might add IN Stock, On Sale would be a nice feature. ??

Claudio thanks for the reply.

The issue is not about barcodes as much as it is a unique identifier (key). A SKU can be anything someone wants to put in the field so it varies from reseller to reseller.

But a UPC/EAN is a registered unique code for almost every physical product sold. For example if you are selling a hammer, the UPC for that hammer is unique and is a standard format.

Example by searching UPC on Google:
HAMMER CURVED CLAW FBGL 20OZ
UPC: 037103226884

Reseller 1 SKU = 6492722
Reseller 2 SKU = 11400N-037103226884-CP
Reseller 3 SKU = 11400N

A SKU for the exact same product can have dashes, added letters or any other information the reseller wants to add.

Let’s take Amazon as I mentioned before. 100% of a new product you want to list has to have a UPC code. Otherwise they would have a 1000 resellers listing the same exact product a 1000 different ways.

In my situation I am important products from multiple distributors and they both sell the same exact product but with slightly different SKU’s. Without having a unique (key) UPC field and code there is no way to keep them straight.

I know there are work arounds and I have created custom fields to handle this. BUT because this is such a fundamental part of any inventory / product management system I can’t believe such a simple feature is not part of the core code.

Look I love Woocommerce and like I said this is not a show stopper because there are work arounds. I was simply surprised it’s not there and wanted to provide feedback to improve the product with such a simple addition.

Is there a better solution than one we have to modify ?
Any suggestions

Yea I realized that afterwards. ??

What about the Pro version, does 0.5.7 also include this feature ?

Oh. I thought this was only going to be a Pro feature so I went ahead and purchased the Pro version and installed that. Does the Pro feature have the same functionally as 1.0.5 now ?

Is the new syntax [yasr_visitor_multiset setid=0 post_id =1234] ?

NO problem. If this does what I want I will gladly upgrade.

I have tested (what feels like) dozens of review plugins and so many are close but don’t have what I need. As far as I can tell YASR is the only one with multisets.

Thanks and I will let you know how it works as soon as possible.

Lee

Thanks I was just staring at the shortcode.php file thinking the same thing.

That’s what I needed.

Appreciate your patience.

Dario, Any luck on the postid parameter code ?

I am sorry maybe I am not explaining myself properly.

IS there a shortcode or way to find the ITEM_ID from within the plugin ?

I will try again to give a few examples:

[myplugin postid= “item_id”]
[wp-review id=”item_id”]
[yasr setid=”item_id”]

Can the ITEM_ID be passed to another plugin?

I believe you pass the Product Name to Ultimate Review Plug in order to match to the right review. My question is there a similiar ITEM_ID variable that can be pass as well ?

[ultimate-reviews product_name=’Smith & Wesson Shield’]
The problem is the product name is not unique enough to be a key field.

function UPCP_Add_Product_Reviews($Product) {
	$ReturnString = do_shortcode("[ultimate-reviews product_name='" . $Product->Item_Name . "']");
	return $ReturnString;
}

If I am not explaining this properly please let me know.

Isn’t there a memory variable that defined when an individual product is called ?

Once a user clicks on a product is that (item_id) setup in memory as a variable ?

Or maybe I am missing that ‘SingleProduct’ is that memory variable you are referring to.

Just to make sure we are on the same page, the problem I am trying to solve is to link a specific product to a Post or Custom Post which contains a product review. This means I need to pass the product id (item_id) to the Review code if a new review is being stored so it is linked to the correct Review.

I guess what I am missing is that once I click on an individual product, UPCP already has to know the item_id because I am viewing the product. Is that item_id able to be viewed by either an existing shortcode or by creating my own shortcode using the $_GET function ?

add_shortcode("product-catalogue", "Insert_Product_Catalog");

function Insert_Minimal_Products($atts) {
	global $wpdb, $items_table_name, $catalogue_items_table_name;

	// Get the attributes passed by the shortcode, and store them in new variables for processing
	extract( shortcode_atts( array(
				"catalogue_url" => "",
				"product_ids" => "",
				"catalogue_id" => "",
				"category_id" => "",
				"subcategory_id" => "",
				"product_count" => 3,
				"products_wide" => 3),
			$atts
		)
	);

Ok. I thought I was missing something. ??

You are the only one that understands the need for multiple sets but I need to call the review from another page.

How are comments handled ? When you put in the new code will that also bring in the user comments for that review as well ?

THANKS !!!

Lee

Sorry Dudo this doesn’t make sense.

If I am calling a unique review for a book FROM another plugin on the site how can you associate that review with that book ?

You are assuming the Page is the only place the review is being displayed but if I want to place the review within a catalog plugin (which I am) then how do I associate that review with that unique product ?

Not sure I am doing a good job of explaining this but in my case the review Page/post is just a placeholder. The actual review is being called from another location not associated with that post. If I simply put [yasr_visitor_multiset setid=0] on the other page, then the review is not unique. Every product displays the exact same review.

Make sense ?

Glad I can help contribute.