# ▶️ Update your products in bulk

Source: https://support.storeconnect.com/articles/how-to-update-your-products-in-bulk · Last modified 21 August 2026

Video: https://vimeo.com/1197572334?fl=sv&fe=ci

### **1\. Export Your Data**

1.  In **Salesforce Dashboard**:

    -   Go to the **Setup Cog** → **Setup**.

2.  Under **Administration** → **Data** → select **Data Export**.

3.  Click **Export Now**.

4.  Select the following objects to export:

    -   **Product2** (Product object)

    -   **Price Book Entry** object.

5.  Click **Start Export**.

6.  You’ll receive an email when the export is ready.

7.  Download the **ZIP file** and extract the CSV files.


---

### **2\. Prepare the Data for Update**

### Sort and Merge Data

1.  Open **Product2 CSV** and **Price Book Entry CSV** in a spreadsheet.

2.  In **Product2 CSV**:

    -   Sort the **ID field** from **Z → A**.

3.  In **Price Book Entry CSV**:

    -   Sort the **Product2 ID field** (associated Product ID) from **Z → A**.

4.  Copy desired fields from **Price Book Entry CSV** (e.g. **ID**, **Unit Price**) and paste into **Product2 CSV**.

5.  Delete any columns not needed for your update.

6.  Remove any rows for products that you do not want to update.


### Rename Columns

-   Rename the columns to the correct **StoreConnect import format**:

    -   `Product:ID` → Product ID.

    -   `Product:Product Name` → Product Name.

    -   `Price Book Entry 1:ID` → Price Book Entry ID.

    -   `Price Book Entry 1:List Price` → Price Book Entry List Price.


### Make Your Edits

-   Make any necessary changes:

    -   **Product Name**

    -   **Prices**

    -   Any other desired fields.

-   Keep in mind: for large datasets or multi-currency stores, this process may become more complex (refer to official documentation if needed).


---

### **3\. Import the Updated Data**

1.  Export your updated spreadsheet as a **CSV file**.

2.  In **Salesforce App Launcher**, go to **StoreConnect Config App**.

3.  Go to **Product Setup** → click **Import Products**.

4.  Click **New Import** → upload your **CSV file**.


### Map Fields

1.  Use **Auto Match** if columns are named correctly:

    -   Product ID → Product Record.

    -   Product Name → Product Name.

    -   Price Book Entry ID → Price Book Entry.

    -   Price Book List Price → List Price.

2.  Verify mappings.

3.  Click **Next**.


---

### **4\. Complete Import and Verify Results**

1.  Click **Import Data**.

2.  Wait a few seconds for the import to complete.

3.  Click **View Results**.

4.  Download the **Success Log** (CSV).

5.  Open log to verify that all records were updated successfully.


---

### **5\. Verify in Salesforce**

1.  Return to **Salesforce** → **Products List View** → refresh the view.

2.  Check updated **Product Names**.

3.  Go into individual products → verify that **Price Book List Price** is updated.


---

## Notes

-   This is a simple example for **basic updates**.

-   For more complex updates (multiple currencies, additional fields), refer to **StoreConnect Documentation** or additional training videos.

-   Always test with a **small sample** first if doing bulk updates across many products.

---

## Follow StoreConnect

- [Email Newsletter](https://getstoreconnect.com/c/lp-newsletter)
- [LinkedIn Newsletter](https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7444956928444862464)
- [YouTube](https://www.youtube.com/channel/UCngKdP2x8l1wcbAKW3tvU8g)
- [LinkedIn](https://www.linkedin.com/company/storeconnect)
- [X / Twitter](https://x.com/storeconnecthq)

## Popular Links

- [Partners](https://getstoreconnect.com/partners)
- [News](https://getstoreconnect.com/articles/news)
- [Events](https://getstoreconnect.com/articles/events)
- [Feature Comparison](https://getstoreconnect.com/how-we-compare)
- [Download a free trial](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000FMkeKUAT)
- [Book a Demo](https://getstoreconnect.com/contact)

## Documentation

- [Help documentation](https://support.storeconnect.com/help-documentation)
- [AI agents](https://support.storeconnect.com/ai)
- [Videos & tutorials](https://support.storeconnect.com/videos-tutorials)
- [Developer reference](https://support.storeconnect.com/developer-reference)
- [Release notes](https://support.storeconnect.com/release-notes)
- [Troubleshooting](https://support.storeconnect.com/troubleshooting)
- [Trust Center](https://trust.getstoreconnect.com/)
- [Status Page](https://status.storeconnect.com/)

## Contact

- info@getstoreconnect.com
- US +1 415 745 3230
- AUS +61 2 8365 2308

100 S Ashley Dr, Suite 600-2461
Tampa FL 33602-600 USA

Level 22, Sydney Place
180 George Street
Sydney, NSW, 2000, AUS

---

StoreConnect Support — https://support.storeconnect.com/articles/how-to-update-your-products-in-bulk