Using Metal Price Logs and Product Price Logs for Jewellery Store Compliance & Auditing
Introduction
When you run an online jewellery store, pricing isn’t just a customer-facing concern — it’s an operational record that touches your accounting, your GST filings, your customer dispute process, and your business intelligence. Most jewellery store owners focus on the customer experience side of pricing (are prices current? are they accurate?) and underinvest in the record-keeping side.
This article covers the price logging features of the ITS Jewellery Price Plugin, how they work, and why they’re more valuable than most store owners initially realise — particularly for compliance, dispute resolution, and business analysis.
What Are Price Logs in the Context of Jewellery eCommerce?
In traditional bookkeeping, a price log is a record of what you charged for goods at specific points in time. For a physical jewellery store, this might mean a register of daily gold rates and the items sold at each rate. For an online store, it means a digital record linking product prices to the metal rates that generated them.
The ITS Jewellery Price Plugin maintains two distinct logs:
Metal Price Log: A timestamped record of every change to a metal rate. Every time you update the gold rate from ₹6,180/gram to ₹6,250/gram, the log records the date, time, previous rate, and new rate.
Product Price Log: A timestamped record of every price change to every product. When a metal rate update causes a product to recalculate from ₹87,500 to ₹89,200, the product price log records this — including the old price, new price, and when the change occurred.
Together, these logs give you a complete audit trail of your store’s pricing history.
Accessing the Logs
Navigate to Jewellery Price → Logs in your WordPress admin. You’ll find separate tabs or sections for the Metal Price Log and the Product Price Log.
Metal Price Log shows entries in reverse chronological order (newest first) with:
- Date and time of the rate change
- Metal type (e.g., Gold 22K)
- Previous rate
- New rate
- Change amount (the difference)
Product Price Log shows:
- Date and time of the price change
- Product name and ID
- Previous price
- New price
- The metal rate that triggered the change
For a store that updates metal rates daily, both logs will have daily entries. Over a year, you’ll have a comprehensive pricing history that’s searchable and filterable.
Compliance Use Cases
GST Audit Trail
In India, GST compliance for jewellery requires accurate records of what price was charged for each transaction and what gold rate underpinned it. If the GST department audits your business, they may ask to verify that your declared transaction values match your product pricing at the relevant dates.
The Metal Price Log provides a verifiable record of what gold rate was active on any given date. If a transaction was processed on March 15th, you can look up the log and confirm that the 22K gold rate active on that date was ₹6,245/gram — and that your product prices on that date reflected that rate.
This creates a paper trail that supports your GST filings. Without logs, reconstructing this information after the fact is difficult or impossible.
Income Tax Documentation
For income tax purposes, understanding your actual revenues relative to cost of goods requires knowing what you paid for materials (gold rate when you purchased stock) and what you charged customers. Price logs help you reconstruct the relationship between your cost basis and your selling prices for any period.
BIS Compliance Records
While price logs don’t directly support BIS hallmarking compliance, they contribute to the overall documentation posture of a compliant jewellery business. A store with systematic, comprehensive pricing records signals operational maturity to any regulatory body reviewing records.
Customer Dispute Resolution
This is where the logs provide some of their most immediate practical value.
Scenario: Customer Claims Price Changed After They Saw It
A customer contacts you saying they saw a price of ₹92,000 on a product last Tuesday, but when they returned to buy it on Thursday it was ₹95,500. They’re upset and questioning whether the price change was legitimate.
Without logs, this is a difficult conversation. With the Product Price Log, you can immediately pull up the exact price history for that product:
- Tuesday, 9:15 AM: Price updated to ₹92,000 (Gold 22K rate: ₹6,180/gram)
- Thursday, 9:20 AM: Price updated to ₹95,500 (Gold 22K rate: ₹6,400/gram)
You can share this information with the customer, showing them the specific gold rate that drove each price, and the timestamps confirming the changes were routine daily updates — not arbitrary price hikes targeting their specific purchase.
This level of transparent documentation defuses most pricing disputes quickly and positions your store as a trustworthy operator.
Scenario: Customer Bought at One Price, Disputes at Fulfilment
Occasionally, a customer will claim at fulfilment that the price they were charged doesn’t match what they saw on the website at the time of purchase. The WooCommerce order record captures the price at the time of order, but if your pricing has changed since then, the product page now shows a different price.
The Product Price Log lets you confirm what price was showing on the date of the order, providing documentation that the customer was charged the correct price at the time.
Scenario: Staff Error in Rate Entry
If someone on your team accidentally enters an incorrect metal rate (e.g., ₹62,000 instead of ₹6,200 — an easy decimal error), prices will spike dramatically until the error is caught. The Metal Price Log records both the erroneous entry and its correction, creating a clear record that the spike was a data entry error.
This matters for your own records (you want to note why a day’s revenue might look unusual) and for any customer who placed an order during the error window.
Business Intelligence Applications
Beyond compliance and dispute resolution, price logs are a genuine source of business intelligence.
Understanding How Price Changes Affect Conversion
If you have access to your WooCommerce order data alongside your price log, you can correlate gold price levels with your conversion rates and average order values.
Questions you can explore:
- Do you sell more jewellery when gold prices are stable, or does volatility not affect your conversion rate?
- How does a ₹200/gram gold rate increase affect your conversion on 22K products versus 18K products?
- Are there price thresholds — specific rupee amounts — where your conversion drops significantly?
This kind of data helps you make better business decisions: which product categories to promote during different gold price environments, whether to absorb small rate increases in your making charges rather than passing them on, and how to set promotion timing.
Seasonal Pricing Analysis
Wedding season, Dhanteras, Akshaya Tritiya — Indian jewellery demand spikes are well known. But how do they interact with gold price levels? If gold is high during Dhanteras, does your conversion suffer? Your historical price log combined with your order history can answer this.
Reviewing Making Charge and Wastage Strategy
Over time, the price logs give you data to review whether your making charges and wastage percentages are competitive. If a competitor begins offering lower making charges and you see conversion drop, the logs help you model the margin impact of matching their rate.
Best Practices for Maintaining Useful Logs
Update Rates Consistently
Price logs are most useful when rate updates are consistent and systematic. If you update rates at varying times of day or irregularly, the log becomes harder to interpret. Establish a routine: update rates at the same time every morning and keep the timing consistent.
Note Unusual Events
While the ITS plugin’s logs are automated, consider keeping a supplementary note (a simple spreadsheet or even a WhatsApp note to yourself) for unusual events: a correction of a data entry error, a day when you intentionally delayed a rate update, or a period when you held prices stable during a volatile market. These notes add context to the automated logs.
Retain Logs for Tax Compliance Periods
Under Indian GST law, records must be retained for a minimum of 5 years. Ensure your price logs (and WooCommerce order records) are backed up and retained for this period. Include price log exports in your regular backup routine.
Export Periodically
Export the price log data to a spreadsheet or CSV regularly (monthly or quarterly). Store these exports in a location separate from your WordPress database — in cloud storage, for example. This protects against log data loss if you ever migrate your website or change hosting.
How to Export Your Price Logs
From the Jewellery Price → Logs screen, look for an export option (typically a “Download CSV” or “Export” button). This generates a spreadsheet-compatible file with all log entries.
For long-term record keeping, create a folder structure like: code Codedownloadcontent_copyexpand_less
/Price Logs/
2025-01 January.csv
2025-02 February.csv
...Monthly exports keep file sizes manageable and create a clear archive structure.
If no native export is available, the log data is stored in your WordPress database and can be exported via a database query or a WooCommerce data export plugin. Contact the ITS plugin support team for guidance on bulk log export if needed.
The Broader Point: Pricing Records as Business Infrastructure
Most small jewellery store owners think of price logs as a nice-to-have feature. In reality, they’re business infrastructure — part of the documentation layer that separates a professionally run operation from an ad-hoc one.
The same stores that maintain careful price records also tend to have:
- Accurate GST filings
- Clean financial statements
- Credible responses to customer disputes
- Data for informed business decisions
The ITS Jewellery Price Plugin’s logging features are built-in — you don’t need to set them up or configure them. Every rate change and every price change is logged automatically from the moment the plugin is installed. The value of these logs compounds over time as you accumulate pricing history.
Conclusion
The Metal Price Log and Product Price Log in the ITS Jewellery Price Plugin are more than a convenience feature — they’re the pricing record-keeping infrastructure that a professional jewellery retail operation needs. From GST compliance documentation to customer dispute resolution to business intelligence, the logs support the full range of operational needs that daily-rate-based jewellery pricing creates.
Get complete pricing automation and audit logs with the ITS plugin →
