How to Bulk Upload & Edit Prices and Supplier

With this feature, you can download your current prices data, update it in a spreadsheet, and upload it back to Ply to apply changes in bulk.

This applies to both new and existing materials. Whether you're onboarding a new supplier or updating pricing across your catalog.

1- You have two options:

From the Catalog, click the three-dot menu and select "Bulk Upload/Update Prices"
​

Or open a specific material and update it directly in the Supplier & Prices tab

​

2- Select 'Update Existing' and export the supplier costs file from your catalog. Edit the price column, and upload the file back.
​

​3- Check the prices and click 'Next Stop' to update.
​

Click on the item to view the applied changes.
​

1- Same as above > From the Catalog, click the three-dot menu and select "Bulk Upload/Update Prices".
​
However, this time select 'Add New' and import your file with the supplier costs.
​
​Note: You can download this template to help format your supplier cost data for import. Simply update it with your materials, suppliers, and pricing information.

​Important: The materials and supplier must already exist in your account.

✅ Add your suppliers first, then bulk-upload pricing.

This feature won't create a new supplier record for you; if the supplier name in your file doesn't already exist in Ply, that row will fail. Add any new suppliers manually under Suppliers before running the import.

✅ Test with a small batch first.

If you're uploading pricing for a large catalog for the first time, try 5–10 rows first to confirm your columns are mapped correctly before running the full file.

✅ Use 'Update Existing' for price changes and 'Add New' for first-time supplier pricing.

Mixing the two in one file is a common source of confusion; if you're just updating costs on materials that already have that supplier attached, use Update Existing; if you're attaching a supplier to materials for the first time, use Add New.

✅ Keep Supplier and Supplier UPC together.

These two columns are linked in the template; see Common issues & fixes below.

"My upload failed and it's flagging a Supplier/Supplier UPC error."

In Ply's bulk import template, Supplier and Supplier UPC are linked; if one is filled in, the other must be too, or that row will fail. See Common Error: Supplier Without UPC During Bulk Upload for the two workarounds (leave both blank and add later, or use a temporary placeholder UPC).

"A row failed and it says the supplier doesn't exist."

This bulk feature updates pricing on materials and suppliers that are already in Ply, it doesn't create a brand-new supplier record. Double-check the supplier name in your file matches exactly what's already set up under the Suppliers tab, or add the supplier there first.

"I don't want to build the file myself, can your team do this for me?"

Yes. This is a common request, especially for larger catalogs or first-time supplier pricing loads. Send our support team your file with materials, supplier(s), and cost per item, and we can coordinate with our data team to get it loaded on your behalf.

"I updated prices in bulk, but a material that had a Preferred Supplier now looks off."

Bulk-loading new supplier costs doesn't remove a Preferred Supplier designation, but it's worth double-checking after a large update. See Setting Up Preferred Suppliers in Ply to confirm the per-material toggle is still set the way you expect.

Can I use this to create brand-new suppliers?

No, suppliers themselves are still added one by one under the Suppliers tab. This bulk feature is for pricing and supplier assignment on materials that already exist, using suppliers that are already set up.

Does this affect Cost to the Client or Cost to the Business?

No, this bulk tool is specifically for Supplier Price under Prices & Suppliers. Cost to the Client and Cost to the Business are separate fields, see Understanding Costs in Ply for how those relate to Supplier Price.

Will this trigger Smart Suppliers to re-evaluate pricing?

If you have Smart Suppliers turned on with "Adjust Automatically," yes, new lowest-cost pricing loaded in bulk can shift which supplier gets flagged as the Smart Supplier for a material. See Smart Suppliers and Preferred Suppliers in Ply for how that works.