Sample Files/advanced_pricing Alternate Method

[GiovanniF-bit]

apologies for my format as this is my first github comment. Our Dev team purchased and installed this extension to use in our adobe commerce environment. I am in the process of uploading a few thousand configurable skus with about 20k+ simple skus. The current format of giving a tier its own line is not clean at scale (Improved Import : Export - Sample Files/advanced_pricing.csv). Having headers for QTY_tier_1, QTY_Tier_2, Price_Tier_1, Price_Tier_2, etc. would be significantly easier as it does not rely on rows of the same product. Does this format already exist for this module? Looking for any suggestions as to assist in

[nikolaev-fb]

Hello @GiovanniF-bit

There is an alternative option in the extension. You can import tier prices using the product import entity.
In this case, the tier prices are stored in a single field as values separated by special characters.
https://github.com/firebearstudio/magento2-import-export-sample-files/blob/master/Improved%20Import%20%3A%20Export%20-%20Sample%20Files/product_all_types.csv

[GiovanniF-bit]

@nikolaev-fb I appreciate that. I am struggling to make sense of how I would use it. for example. 12 shirts = $15, 24 Shirts = $14, 48 shirts = $13.50.

In this format, "General,360,0,3,All|Retailer,360,0,3,All" how would that look?

[nikolaev-fb]

The format is:
customer group, qty, price, percent, websites

For example, value General,0,0,10,All|General,5,0,15,All means:
First tier price with qty > 0 and discount 10% for group General for All websites
Second tier price with qty > 5 and discount 15% for group General for All websites

In your case (fixed price discount) you should use the following format:
General,12,15,0,All|General,24,14,0,All|General,48,13.5,0,All

[GiovanniF-bit]

@nikolaev-fb I sincerely appreciate that. this: "customer group, qty, price, percent, websites" made it clear. thank you