automatically use ean in product amazon settings

Hi @stumpyhead

Thank you for reaching out to us.

Depending on what kind of field your EANs are currently located in Woocommerce, we could write you some custom code (if you are a pro user) that could pull the EANs from a custom field where they are located in Woocommerce.

If you are saying you don’t have your EAN data entered anywhere in Woocommerce, then I would suggest using a CSV Import/export. You can export your products via CSV, then add your EANs to your products in the “_amazon_product_id” field, then upload the CSV back to Woocommerce.

https://docs.wplab.com/article/102-csv-import-plugins-amazon

Kind regards,

John

Hi rthanks for getting back to me… I’m not ‘yet’ a pro user but I soon will be once I’m sure I can accomplish what I need. That said out of all the solutions I have tried yours is the best by a ‘massive’ margin. Most intuitive to use and by far the best value for money. Anyway.

My eean codes are stored in inventory. That’s to say that, when I go to the edit product page and click on inventory (under product data) the ean code is there under sku. However, when selecting the input for product ID in profiles I don’t see ean in there.

I was looking for a workaround but I’m now hoping that the pro version will fix this? Is there a reason why sku you is available from product data and ean isn’t?

I may not have explained it very well so if you’d like my admin details you’re welcome to have a look.

Thanks aagain

Regards

Thank you for your kind words @stumpyhead

So you store the EAN as your SKU in Woocommerce. That is fine. You can add the shortcode “[product_sku]” to your product ID field in the listing profile of WP-Lister, which will have WP-Lister pull the SKU from Woocommerce and enter it into the “product ID” field in Amazon.

Kind regards,

John

Hi

I didn’t explain myself clearly… I have sku and ean… Apparently woocommerce doesn’t have ean so it must have been added by my supplier’s plugin. In inventory I have.

SKU

EAN

now tthat I know that it’s not a standard thing (taxonomy? Meta?) I’ll have to find out how to get it into the product id in the profiles.

Ho iI’m going to do that I have no idea. Apparently though it’s something that the pro version isn’t going to fix which is very disappointing because custom coding is something I can I’ll afford at the moment.

Thanks

Regards

Hello again.

We do offer custom coding to our pro users without an additional charge, but not lite users. With that said, if you can tell me what kind of field it is, we can point you in the right direction.

Kind regards

John

Ok tthat’s great news. I asked my supplier about this and this is the thread. I’m only putting it here because I don’t want you to open a can of worms and end up messing around with something for free that’s going to be more than just a quick and easy fix and be more work/headache than the $50 is worth.

Me:

I am under the understanding that woocommerce doesn’t have ean codes as standard. I’m presuming that your stock manager plugin ads this field to inventory. If so, what kind of data is it?

I’m trying to use wp lister to list on amazon but your ean numbers are not available in the attributes or other product data when creating profiles. Is there a tag or something that I can use to fetch the data? Something like: product_ean or meta_ean?

Supplier:

We will import the top level EAN as an attribute (meta value), but this does not handle EANs for variants unfortunately.

Me:

That’s great… Thank you for the help it’s very much appreciated.

What do I need to do my end for it to update my products?

Supplier:

Some sort of custom integration using our XML feed or CSV files.

You’ll need to hire someone to do this and add some custom fields to your WP.

Me:

Sorry what I meant is… If I update all my products from stock manager… Will the ean then be in the attributes?

Regarding varients. Does this mean that products that come in different colours will have the same ean?

Supplier:

Stockmanager will import single variant EANs, products with variants are not imported and are different per option.

Me:

What about the attributes? I’m a little confused as to how I go about it.

Will the ean codes be added to the attributes when I update the products from stock manager or will I have to use your xml files to import them to attributes?

Supplier:

Simple answer is you can’t do it out the box, unless the products do not have variations (options), so probably 1200 or so products.

You will need to add the variant (options) EANs from our XML or CSV files if you wish to have them inside your WordPress for any items that have variations (options).

Obviously I’m baffled by this. To my logic, if the ean codes are stored in the database somewhere then it should be possible to fetch them and input them??? But that leaves products like clothing which have options such as small, medium, large etc. Obviously I can set up profiles for that right?

Anyhoo… IIf it’s a quick and easy fix for you to be able to add an option whereby I can fetch the ean and pop it in product ID then I’ll purchase the pro version.

Thanks again for your time

Regards

Hi @stumpyhead

Your supplier says they are custom meta fields.

If that is accurate, we have a shortcode for custom meta fields that can be used in the listing profile of WP-Lister. It is “[meta_YOUR-CUSTOM-FIELD]” where “YOUR-CUSTOM-FIELD” is the label of the custom field.

That shortcode will pull values from the custom field for each product.

As for the variable listings, the supplier says you have to manually perform this process. So you would need to manually add the EANs to the variations via your own method. Either manually, in bulk using a CSV import/export or even via the database in bulk if you are handy with databases.

Kind regards,

John

Ahhhh…. I expoerted my products as csv, searched and there’s a column header with: “meta: _ean”

So wwould it be [meta_ean] that I enter in the product id field?

Thanks again for the help

Regards

Hi @stumpyhead

You would insert all of your EAN values into the “meta_ean” column.

This will have each EAN inserted into the product ID field of each edit product page.

Then, all you need to do is make sure the “[amazon_product_id]” shortcode is set in the “Product ID” field of the listing profile in WP-Lister, and that will have WP-Lister pull the EAN value from each edit product page for each listing on Amazon.

Kind regards,

John

Ahhh… I just put [meta_ean] in product ID and set product ID Type to EAN… I have quite a lot of errors in the report but it looks like the ean codes are getting fetched and put in the correct place.