What to do if the supplier has changed the price list structure

Typical changes to the price list structure

Suppliers modify their prices for various reasons: switching to a new accounting system, expanding their product range, or complying with legal requirements. Understanding the types of changes helps diagnose the problem more quickly.

1. Renaming columns

The most common change is renaming columns:

• "Price" → "Retail Price" - clarification of the price type
• "Name" → "Product" - simplification of the name
• "Article" → "SKU" - transition to international terminology
• "Remaining" → "Availability" - change of display logic

2. Adding new columns

Extending the structure with new fields:

• Technical specifications: "Weight", "Dimensions", "Color", "Material"
• Logistics: "Delivery time", "Minimum quantity", "Order quantity"
• Marketing: "New", "Special Offer", "Discount", "Bestseller"
• Compliance: "Country of Origin", "TN VED", "Certificate", "Barcode"

3. Changing the order of columns

Rearranging columns while preserving names. If your import is configured by column numbers (A, B, C or 1, 2, 3) rather than by names, this will cause errors.

4. Changing the data format

Modification of information presentation:

• Prices: "1500.50" → "1,500.50 rubles" (separators and currency added)
• Remaining: "15" → "In Stock" / "Out of Stock" (text display)
• Articles: "A12345" → "A-12345" (separator added)
• Dates: "01.10.2025" → "2025-10-01" (format changed)

5. Changing the file format

Switching to another file format:

• XLS → XLSX: Updating to the new Excel format
• CSV → XML: transition to a structured format
• TXT → JSON: API download modernization
• Single-leaf → Multi-leaf: division into categories

6. Structural changes in sheets

More complex modifications:

• Adding a header with company information (shifting data down)
• Merging cells in headers
• Grouping products into categories with subheadings
• Adding summary rows or pivot tables

Problems with changing the structure

An unplanned change to the price list structure creates a cascade of problems that impact all of the store's business processes.

Stop synchronization

Direct consequences:

• Price list import fails with an error
• Price and inventory updates are no longer available.
• New products are not added to the catalog
• Discontinued items remain on sale

Commercial risks

• Loss of sales: Items with zero remaining stock continue to be displayed as available.
• Outdated prices: old prices are shown, which leads to losses or customer refusals
• Cancelled orders: customers order products that are not in stock
• Reputational damage: negative reviews due to outdated information

Operational problems

• Increased support load: Clients call to check availability and prices
• Handmade: Managers are forced to process price lists manually
• Data inconsistency: different prices on the website and from managers
• Delays in order processing: the need to clarify each position

Technical difficulties

• Urgent need to adjust import settings
• Risk of incorrect field mapping (column confusion)
• Loss of price change history
• Conflicts when multiple integrations are running simultaneously

5 steps to solve the problem

A systematic approach allows you to quickly restore import functionality and minimize losses. Follow this algorithm for effective problem resolution.

Step 1: Diagnosis and analysis of changes

Actions:

1. Get the new version of the price list
   • Download the latest file from the supplier
   • Save with date stamp: price_supplier_2025-10-21.xlsx
   • Download the previous working version for comparison
2. Make a visual comparison
   • Open both files in Excel or Google Sheets.
   • Compare the column headings in the first row.
   • Check the order of the columns
   • Note the new or removed columns
3. Commit all changes
   • Create a mapping table: "Was" → "Became"
   • Note the data format changes
   • Check the number of rows with data

Step 2: Update field mapping

Reconfiguring column mappings:

1. Open the import settings
   • Find an import profile for this supplier
   • Go to the "Field Mapping" section.
2. Update the matches
   • Change the column names to new ones
   • If column numbers were used, replace them with names.
   • For new columns, define the purpose
3. Set up data processing
   • Update regular expressions for parsing
   • Adjust format conversion rules
   • Set up price extraction from new formats

Step 3: Test Import

Checking settings before use:

1. Run test mode
   • Use the Preview feature
   • Check the first 10-20 lines of import
   • Make sure the data is read correctly.
2. Check data processing
   • Prices are parsed correctly (without currency symbols)
   • The remainders are converted into numbers
   • Articles are compared with existing products
   • New products are correctly identified
3. Import to a test directory
   • Create a backup copy of the database
   • Run the import on a test category (5-10 products)
   • Check the results in the admin panel
   • Make sure that prices and stocks have been updated correctly.

Step 4: Full import with monitoring

Starting an update of the entire catalog:

1. Create a restore point
   • Full database backup before import
   • Export current prices to a separate file
   • Saving a snapshot of the system state
2. Run the import
   • Enable verbose logging
   • Monitor the process in real time
   • Record warnings and errors
3. Monitor the results
   • Number of records processed
   • Number of updated products
   • New items in the catalog
   • Errors and missing lines

Step 5: Documentation and Prevention

Securing the solution:

1. Document the changes
   • Date of change of structure by supplier
   • Detailed description of modifications
   • Updated mapping settings
   • Screenshots of import settings
2. Update instructions
   • Documentation for working with this supplier
   • Contact information of the responsible person
   • Procedure for action in the following changes
3. Contact the supplier
   • Specify the reason for the change in structure
   • Request advance notice of future changes
   • Discuss the possibility of a stable data structure
   • Get contact information for a technical specialist

Automatic structure recognition

Modern price list management systems use intelligent algorithms to automatically adapt to changes in the structure. This minimizes downtime and reduces the need for manual intervention.

How AI recognition works

1. Analysis of column headings

The system uses semantic analysis to determine the purpose of columns:

• Price synonyms: "Price", "Cost", "Rate", "RRP"
• Product IDs: "Article", "SKU", "Code", "ID", "Code", "Vendor Code"
• Remaining: "Remaining", "Stock", "Quantity", "Available", "Availability", "Qty"
• Titles: "Name", "Name", "Title", "Product", "Product", "Description"

2. Analysis of cell contents

If the column headings are not informative, the system analyzes the data:

• Numeric values with 2 digits: probably prices
• Integers 0-1000: possibly remnants
• Unique short strings: articles
• Long text fields: names or descriptions

3. Statistical analysis

Estimation of the probability of column assignment:

• Percentage of non-empty cells
• Uniqueness of values
• Distribution of data types
• Correlation with previous versions of the price list

Automatic field mapping

Operating algorithm:

1. The system receives a new version of the price list
2. Detects differences from the previous structure
3. Applies recognition algorithms to each column
4. Constructs hypotheses of correspondences: "Price" → "Retail price" (98%)
5. Prompts the user to confirm automatic mapping
6. When confirmed, applies the new settings.
7. Remembers the pattern for future changes

Smart hints

The system assists the user with manual configuration:

• Color highlighting: high probability - green, low - red
• Confidence percentage: "Article → SKU (95%)"
• Examples of data: show first 5 values from column
• Warnings: "This column contains non-numeric values for the Price field."

Handling non-standard formats

Automatic adaptation to data characteristics:

• Price parsing: Extracting numbers from "1,500.50 rubles" → 1500.50
• Conversion of balances: "In stock" → 999, "Out of stock" → 0
• Normalization of articles: removing spaces, converting to a single case
• Date processing: recognition and conversion of various formats

How to prevent future problems

Proactive measures help avoid critical situations when suppliers change their price structure.

Price versioning

Storage organization:

• Automatic archiving: each downloaded version is saved
  • Path: /archive/supplier_name/2025/10/price_2025-10-21_14-30.xlsx
  • Storage: 90 days for analysis and rollback
• Structure Change Detector: automatic comparison with the previous version
  • Calculating the hash of a file structure
  • Compare column list
  • Field order analysis
• Mapping version history: saving all field mapping settings
  • Date settings were changed
  • Author (user or automation)
  • Ability to roll back to a previous configuration

Change notification system

Setting up alerts:

1. Changing the file structure
   • Email notification: "Changes detected in Supplier X's price list"
   • Contents: list of changed columns, proposed mapping
   • Action: Confirmation required before import
2. Critical data deviations
   • Price changes of more than 30%
   • The number of goods fell by more than 20%
   • Mass zeroing of balances
   • Duplication of articles
3. Lack of updates
   • The price list hasn't been updated for 3+ days (customizable)
   • The file has been unavailable via FTP/Email for more than 24 hours.
   • Repeated import errors

Communication with suppliers

Building processes:

• Data Structure Agreement
  • Appendix to the contract with a description of the price list format
  • Obligation to notify within 14 days
  • Change approval procedure
• Technical contact
  • Email/phone number of the supplier's IT specialist
  • Operational channel for emergency questions
  • Telegram/WhatsApp for quick communication
• Regular checks
  • Monthly price stability analysis
  • Quarterly data quality discussion
  • Feedback on integration issues

Standardization of internal processes

Organization of team work:

• Documentation: detailed instructions on working with each supplier
• Checklists: step-by-step guides for common problems
• Knowledge Base: accumulation of experience in solving problems
• Employee training: regular training on working with price lists
• Duty: appointment of a person responsible for import monitoring

Technical protection measures

• Sandbox testing: Checking new prices on a copy of the database
• Staged rollout: gradual application of changes by category
• Automatic rollback: automatic rollback in case of critical errors
• Data quality monitoring: control metrics after each import
• A/B testing: comparison of the old and new structure for some goods

Conclusion

A change in a supplier's price list structure is an inevitable occurrence for any online store. The key to successfully resolving this issue is rapid diagnosis, a systematic approach to import restoration, and proactive preventative measures.

Key findings

• Reaction speed is critical: Every day of import downtime results in a loss of 15-25% of sales
• A systematic approach is more effective than chaotic actions: Follow the 5 steps to solve the problem
• Automation reduces risks: Intelligent structure recognition saves hours of work
• Prevention is cheaper than cure: A notification system and agreements with suppliers prevent downtime
• Documentation is required: Change history helps avoid recurring problems

Recommendations for different business sizes

Small business (5-20 suppliers):

• Use systems with automatic structure recognition
• Keep a simple change log in Google Sheets
• Set up email notifications about import problems

Medium business (20-100 suppliers):

• Implement a professional price list management platform
• Hire or train an integration specialist
• Establish notification agreements with key suppliers
• Set up versioning and automatic backups

Large business (100+ suppliers):

• Use enterprise solutions with ML analysis
• Create a data management department
• Implement strict supplier requirements in contracts
• Develop an automated monitoring and recovery system