Batch Update Inventory Components (PF8)

 

Option 1:
Automatic updates of multiple stock numbers of a single Style:

Menus > Maintenance
Maintenance > Preferences > Parts – Raw Materials
Parts Preferences tabpane

Preference #6. Edit Components: Prompt for Batch Update

---

Option 2:
This technique allows full flexibility:

Batch update quantity in the components window from the Inventory Style Master.

MenusSQL > Inventory Finished Goods > Click on Components

In this case we will update the sewing price from to 4.00 for all styles that being with 100 and have SEW as a component.

To update the components, we need the sequence number located in the red box (185) above.

To get all the components quickly we will use the SQL Command Center (MenusSQL > SQL Command Center)
and copy and paste the following SQL query:

---

SELECT comp_seq,comp_qty,comp_ivnum,comp_part_code FROM components

WHERE comp_part_code=’SEW’
and
comp_ivnum LIKE ‘100%’;

---

Paste above in white area.

Change to your part code (SEW to xxx).

Change to your style number (100 to xxxx).

Click Execute or Excel.

Your Export File Should look like this:

I updated comp_qty to 4. This is the new sew price.

Remove two columns in red box. They are there for you to confirm the requested data.

Save as csv or txt.

Next the update process:

MenusSQL > Inventory Finished Goods > Commands > Build Styles > Import Styles and Other Data

The red box click the type of file you saved as.

Blue box click update records.

Green box click Insert Components.

Click Load Import list

If everything looks good Click Ok Import.

.

Check your data.

Inserted 12/18/2025 – HS
Modified 5/28/2026 – AG