WP All Import – Fixed prices

Hello @martin94,

Unfortunately, importing the prices directly into the meta field will not work as it has to go through the formatting function to store it in a specific format in DB. the “quantity:price” format is just for importing.

The best way to handle this is to create an import file only with tiered pricing data and set it on a cron job.

I hope this helps.

Hello !

Thank you for getting back to me.

I don’t understand your reply though.

The best way to handle this is to create an import file only with tiered pricing data and set it on a cron job.

That’s exactly what I’m trying to do but I don’t know how to update only the price and not the other fields,

WP All Import doesn’t allow you to select the “Only import Fixed Prices Rules” but allows you to update certain custom fields.

How to make a cron when you can’t update only the prices ?

Thank you,

Martin

Hello @martin94,

I mean to create an import file that will contain only tiered pricing data and product ID (for matching). That way, you can import the whole file, but only tiered pricing data will be updated.

Hello ! Thank you for your other reply

It seems like i’m not being clear.

It seems like you can’t import only the tiered pricing data in WP All Import.

Have you used WP Import to update just price data before ?

Either you import all your data in one file, or if you want to update just a certain data you have to choose before hand what you want to update (title, custom field, image …)

There isn’t an option for updating just ‘Tiered Pricing data’.

Here are the options available to update : https://ibb.co/mN2PMXV

So no, I can’t just update my tiered pricing data otherwise all the rest of my data will be overridden with nothing.

Do you understand what I’m saying ? It feels like i’ve been trying to say the same thing for three post now, but I must not explain very well :’)

In any case, thank you greatly for your help,

Let me know if you need more information,

Martin

• This reply was modified 2 years, 11 months ago by martin94. Reason: Added screenshot link

Hello @martin94,

When your file contains only tiered pricing data and you choose this option:
https://ibb.co/dJXGq6M WP All Import will import tiered pricing data and all other data will not be changed since you don’t have it in your file.

Please reach out to the WP All Import support to get more information on how to do this.

Do not forget to include product IDs or SKU into your import file.

I hope this makes sense.

Hello ! Thanks for your reply

I don’t really understand, because in WP you clearly have two options :

1 – You replace ALL the posts data already present in your website by the data in your import file
2 – You replace only specific posts data by selecting beforehand in the “Which data to update” list : https://imgbb.com/mN2PMXV

There is no “Tiere price” option in that list.

And if I import just the data with SKU and variable price, the other fields are emptied (title, content …).

Would it be possible maybe to pay for extra support ? I’m quite in a hurry with this website

Thanks

Hello!

I’m pretty sure you can update only provided in an import file data. I mean it will not wipe out the rest fields that are not listed in the file.

Yes, you can text me by email (bycrik @ gmail.com) to pay for a couple of dev hours to check this.

Hey,

Thanks for replying,

As you can see here : https://www.wpallimport.com/documentation/syncing-stock/

The way to update stock or price is by choosing the “Choose which data to update” ??

Cheers,

Martin

Hey,

That is odd as I was pretty sure I did this when developed this WP All Import integration.

Anyway, here are the meta keys the plugin utilizes, maybe it would work to put them in specific metakeys to update:

“_percentage_price_rules”
“_fixed_price_rules” “_tiered_price_rules_type”
“_tiered_price_minimum_qty”