Price not adjusting

The markup is applied when you use the Set regular price or Set sales price functions (on the Variations tab). Have you done that and the markup is still not being applied?

How would this work if I had a spreadsheet with a bunch of attributes and pricing
For example:
Attribute Name | Attribute Value | Attribute Global | Attribute Visibility | Attribute Price

How would I be able to mass import these global attributes?
I have 100’s potentially 1000’s of attributes that I will need to import.

I don’t know that WooCommerce gives you the ability to import global attributes directly. They have to be added to the products in a CSV file you import, and then WooCommerce will create the global attributes. Since the WooCommerce import feature doesn’t allow metadata, we can’t include the markup for those attributes.

https://docs.woocommerce.com/document/product-csv-importer-exporter/#section-7
https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

Since Markup by Attribute’s scope is to reprice product variations once the attributes are created, I’m afraid I can’t help you with that.

Hi,

This issue is happening with me as well. I have added my markup in my attributes, and have set the Regular variation price, and I can see the attribute on the front end (i.e. My Item (Add $2.50), but the price does not adjust when I add it to the cart.

I have the latest version of WP and Woocommerce.

Please help.. thank you!

Hey ok so new sceneario.
I already imported the 1000+ attibute terms..
How could I add the markup to those attributes via a spread sheet?
Attribute name | Attribute Value | Attribute Markup

Please advise. Thank you

edit: Is it possible to edit the plugin to do this?
Or can you send me any info on the MySQL DB structure so I could attempt a SQL import.
Again, please do advise on the best way to accomplish my goals.

Also, I think the woocommerce tool does allow the importing of custom meta data now.

• This reply was modified 3 years, 9 months ago by miroku0000.
• This reply was modified 3 years, 9 months ago by miroku0000.

@skylerdesign

How did you set the variation prices? Markup by Attribute does not adjust the price in the shopping cart, but sets the adjusted price when you use the Set regular prices function on the Variations tab. It’s intended use is for when you have so many variations using global attributes that calculating and setting the prices manually becomes nightmarish.

If you’ve set the markup in the attributes then used the Set regular prices function, but it still doesn’t work, then it may be that you have variations with “Any” in an attribute that has a markup. For instance, if the Size X-Large has a markup, then you cannot have a variation with “Any Size”. WooCommerce will pick that variation instead of the one you intended.

If it still doesn’t work, we may need to look deeper.

@miroku0000

If you are using phpMyAdmin or something that imports CSV files, there is a way to do it, providing you can find the term_id’s of all the attribute terms in question.

The markups are kept on the wp_termmeta table.

• meta_id: assigned by WordPress
• term_id: the ID number of the term you are adjusting
• meta_key: always “mt2mba_markup”
• meta_value: some value like “+2.5%” or “-2.95”

The tough part of this will be getting the term_id’s. I found that an export of the wp_terms table in CSV format helped me find those.

I successfully imported a file that contained the following, and it updated attribute Size, term X-Large.
1000,31,mt2mba_markup,25%
Note that I provided a meta_id. I simply picked a number higher than the highest meta_id already in use.

Any additional examples you could provide?
Or guidance. Would I be able to match the term id to the term name?

The ID and Meta ID are both generated upon creation if I’m not mistaken.
So in order to match the markup price on the sheet, I would need to link it to the attribute value.

Please see the image at this link below
https://firealpaca.com/get/hbvtOmUJ

Woocommerce product import now has a field for importing as meta data

Yes, but that is the metadata associated with the product, not the metadata associated with the global attribute. The actual amount of the calculated markup for each product variation can be imported, but the global attribute metadata can not.

For instance, assume the term Blue for the attribute Color has a 2% markup. All this appears on the Products → Attributes → Color page. This information is stored in the wp_terms, wp_term_taxonomy, and wp_temmeta tables.

A blue tee-shirt for 17.95, then, will have a 0.36 markup. This information is kept in the wp_posts and wp_postmeta tables.

What you are seeing in the import and export is from the wp_posts and wp_postmeta tables. But what you are asking for is to import into the wp_termmeta table. The only way to accomplish that, at this time, is via a WordPress WXR (XML) file. Which, I suspect, would be crazy difficult.