Jewellery Price Breakup Table For WooCommerce

Jewellery Price Breakup for WooCommerce helps store owners display a clear and transparent pricing structure for jewellery products. Break down the total product cost into components like Gold Price, Diamond Price, Making Charges, Taxes, and more. This plugin improves customer trust, enhances clarity, and increases conversions by showing exactly how jewellery pricing is calculated.

Installation

↑ Back to top

Requirements

↑ Back to top

• WordPress:5.2+
• WooCommerce: 5.0.0+
• PHP: 7.4 or higher

Upload and Activation

↑ Back to top

1. Download the jewellery-price-breakup-for-woocommerce.zip file.
2. Go to: WordPress Admin > Plugins > Add New > Upload Plugin.
3. Choose the file you downloaded.
4. Click Install Now and then Activate Plugin.

More info on Using Plugins.

Overall logic and purpose

↑ Back to top

Setup and Configuration

↑ Back to top

After activation, go to: WooCommerce > Settings > Jewellery Price Breakup to configure the plugin.

General

↑ Back to top

Single Product Page Position

Use this setting to choose where the Jewellery Price Breakup Table For WooCommerce will appear on the single product page. Select a position from the dropdown, such as:

• Top of Product Page
• Below Product Slider (May Not Work with Some Themes)
• Before Product Title / After Product Title
• After Short Description
• Before / After Quantity Input Field
• Before / After Add to Cart Button
• After Product Meta Information

This gives you flexibility to place the table exactly where you want within the product page layout.

Hide Tax and Making charges

Enable these options to hide the tax amount or making charges from the Jewellery Price Breakup Table For WooCommerce on the product page. This helps you control which cost components are visible to customers, based on your store’s display preferences.

Materials

The Add Material section allows you to create and manage the materials used in your jewelry products. Each material includes a unique ID, name, price, and optional API type mapping. This data is used to calculate and display the price breakup on the product page.

Fields Description

Field	Description
Material ID	Automatically generated unique ID for each material (non-editable). Used internally for reference.
Material Name	Enter a descriptive name for the material (e.g. 18 KT Rose Gold, Gold 24K).
Price per Unit (carat, gm)	Set the price of the material per unit (carat or gram). This price will be used to calculate the cost of the metal in the price breakup table.
Material Type (For API)	Select the appropriate material type for API integration. This allows the system to fetch live prices if available. Examples: Gold 18K, Gold 22K, Gold 24K, Silver, etc.

• Remove – Click the Remove button to delete an existing material row.
• Add New Jewellery Price Breakup – Click this button to create a new material entry.
• Sync Now – Click Sync Now to fetch and update the prices for all materials that have an assigned Material Type (For API).

Disclaimer Text

This setting allows you to add a custom disclaimer message that will be displayed below the jewellery price breakup table on the product page, helping you inform customers about the accuracy and purpose of the displayed pricing information.

API

↑ Back to top

The API settings allow you to enable live metal price updates in your store. When configured, your plugin will automatically fetch the latest metal prices from apised to keep your product pricing accurate and up to date.

You can enable or disable the Gold Price API as needed. When enabled, the system will connect to apised and fetch live metal prices using your API key.

Enter your API key from apised in the provided field. To generate your key, go to apised.com, sign up for an account, log in to your dashboard, and create a new API key. Copy the key and paste it here.

You can also set how often the metal prices should automatically update, in minutes. For example, entering 1440 will update the prices every 24 hours, while 60 will update them every hour. This ensures your product pricing stays aligned with current market rates.

Configure Material Types for API Sync

After enabling the API, you can configure your materials to link with the live price updates. In the Materials section under General Settings, you will find a field named Material Type (For API) for each material you have added. Here, you can select the appropriate material type from the dropdown options, such as GOLD 24K, GOLD 22K, GOLD 21K, GOLD 20K, GOLD 18K, GOLD 16K, GOLD 14K, GOLD 10K, SILVER, PLATINUM, or PALLADIUM.

By selecting the correct API material type for each of your materials (for example, assigning GOLD_18K to your “18 KT Rose Gold” material), the system will know which live price to fetch from the API. Once all materials are mapped correctly, the plugin will automatically update their prices during the scheduled sync, or you can click Sync Now to update them immediately.

Style Option

↑ Back to top

You can quickly change the appearance of your price breakup table by selecting from a range of predefined styles. These ready-made designs allow you to instantly give your table a professional look without any manual customization.

Simply choose your preferred style from the dropdown list, which includes:

• Modern
• Elegant
• Luxury
• Royal
• Regal
• Minimal

Once selected, the chosen style will automatically be applied to your table layout and colors.

If you want full control over the appearance of your table, select the Custom option from the style dropdown. This will unlock a variety of color customization settings, allowing you to create a design that perfectly matches your website’s theme. You can customize:

• Heading Colors – Set the background and text colors for table headings.
• Subheading Colors – Set the background and text colors for table subheadings.
• Odd/Even Row Colors – Set the background and text colors for alternating rows.
• Price Colors – Set the colors for regular and discounted prices.
• Total Row Colors – Set the background and text colors for the total row.
• Disclaimer Font Size – Adjust the font size of the disclaimer (e.g., 16px).
• Disclaimer Text Color – Choose the text color for the disclaimer.

Disclaimer Style

In this section, you can customize the appearance of the disclaimer text displayed below the price breakup table. You can adjust the following:

• Disclaimer Font Size – Set the font size (in pixels) for the disclaimer text.
• Disclaimer Text Color – Choose a text color using the color picker to match your site’s design.

These settings help ensure your disclaimer remains readable and visually consistent with the table style.

Import Export Options

↑ Back to top

The Import / Export feature allows you to easily back up, transfer, or bulk update jewellery price data across different products or categories on your store. This is especially helpful when you want to quickly manage pricing information for multiple products without editing each one individually.

Export Options

You can export the existing jewellery price breakup data in an .xlsx format. This file will contain all the configured materials (metal, diamond, making charges, etc.) and their associated price details for the selected products or categories.

Choose Products or Categories for Export

• Select Products: Allows you to pick specific products from your store to export their price breakup data. Only the selected products will be included in the exported file.
• Select Categories: Instead of choosing individual products, you can choose entire product categories. All products under the chosen categories will be included in the exported file.
• All Categories: This option will export jewellery price data for all products in your store.

Once you make your selection, click on Export Products to download the .xlsx file containing the price breakup data.

Import Options

You can quickly add or update jewellery price breakup data for multiple products or variations using the Import Products Jewellery Data option. This helps you manage large sets of data without editing each product individually.

First, click on Download Sample XLSX to get the sample file with the correct format. Open the file and fill in your own product data by following the same column structure. Each row represents a product or variation and contains details for materials, making charges, and diamonds.

Once your sheet is ready, click Choose XLSX File to select your file, and then click Import Products. The system will automatically map the data based on the ProductID and VariationID, and update the respective product’s jewellery price breakup details.

Column Details

• ProductID – The main product ID from .
• VariationID – The variation product ID (leave blank if not a variation).
• sku – Optional SKU of the product or variation.
• ProductName – Product name (for reference only).
• VariationLabel – Variation label like size or color (leave blank if not a variation).
• _name0 – Material ID from your defined materials list.
• _material_weight0 – Weight of the material (in grams or carats).
• _making_price0 – Regular making price per gram.
• _making_sale_price0 – Sale making price per gram.
• _diamond0 – Diamond name.
• _color0 – Diamond color (e.g. F–G, White).
• _shape0 – Diamond shape (e.g. Round, Oval).
• _weight0 – Diamond weight (in carats).
• _carat_price0 – Regular price per carat.
• _sale_carat_price0 – Sale price per carat.

To add multiple materials or diamonds, add a new set of columns with the next index like _name1, _material_weight1, _diamond1, _color1, and so on.

Important Notes

• Always use the sample file as a base to avoid formatting issues.
• If both ProductID and VariationID are provided, the data will link to the variation; if only ProductID is provided, it will link to the main product.
• Existing data for the selected products will be replaced with the new imported data.
• Make sure all product IDs and variation IDs exist in your store.

Product-Level Configuration

↑ Back to top

On the Edit Product page, you can define detailed jewellery price breakup per product. This allows you to add materials (like gold, silver, platinum) and diamonds with their respective weights, costs, and selling prices.

Materials Configuration

↑ Back to top

Field	Description
Material Type	Select the material (e.g., Gold 22K, Gold 24K, Silver, Platinum).
Weight (Gram)	Enter the material weight in grams.
Making Cost	Enter the actual making cost.
Making Sale Cost	Enter the selling price for making charges.
Actions	Delete material row if not required.

Use the Add Material button to add multiple materials for a product.

Diamonds Configuration

↑ Back to top

Field	Description
Name	Enter diamond name or identifier.
Color	Specify the diamond color.
Shape	Add diamond shape (e.g., Round, Princess, Oval).
Weight (Carat)	Enter the diamond weight in carats.
Price (Per Carat)	Enter the base price per carat.
Sale Price (Per Carat)	Enter the selling price per carat.
Actions	Delete diamond row if not required.

Use the Add Diamond button to add multiple diamonds for a product.

Simple Product Configuration

↑ Back to top

You can configure the detailed Price Breakup tab on any simple product edit page in WooCommerce. This allows you to create a transparent cost structure by adding materials, diamonds, and making charges that contribute to the final product price.

Adding Materials (Metals)

1. Use Predefined Materials
   • The system allows you to use the materials you’ve already defined under the Materials section (for example: 18 KT Rose Gold, Gold 24K, Gold 22K, etc.).
   • This ensures accurate and consistent pricing, especially if you’re using the live metal price sync via the apised API.
2. Select Material Type
   • From the Material Type (For API) dropdown, choose the appropriate type such as Gold 24K, Gold 18K, Silver, Platinum, etc.
   • This will link the material with the correct metal type for fetching live rates if API sync is enabled.
3. Enter Material Details
   • Weight (in grams) – Specify the exact weight of the metal used in the product.
   • Making Cost – The base making charge for the material.
   • Making Sale Cost – The sale price for the making charge if you are offering a discounted making rate.
4. Add Multiple Materials
   • Click Add Material to include additional materials if your product uses more than one type of metal.

Adding Diamonds

1. Enter Diamond Details
   • Name – The name or label of the diamond (e.g. FG-SI Round-22 Nos.).
   • Color – The color grade of the diamond (e.g. F–G, White).
   • Shape – The cut or shape of the diamond (e.g. Round, Oval, Princess).
   • Weight (Carat) – The total carat weight of the diamond.
   • Price (Per Carat) – The regular price per carat.
   • Sale Price (Per Carat) – The sale price per carat if applicable.
2. Add Multiple Diamonds
   • Click Add Diamond to add more diamonds to the product’s breakup if needed.

Final Configuration

• You can add multiple materials and multiple diamonds for a single product.
• The system will automatically calculate the total cost based on the weights, prices, and making charges you provide.
• All these details will be used to build the Price Breakup Table shown on the product page.

Variable Product Configuration

↑ Back to top

In WooCommerce, variable products allow you to create different variations of a product (such as size, color, or weight). Each variation can have its own Price Breakup configuration, enabling you to define specific material and diamond details for accurate cost calculation.

To configure the Price Breakup for each variation:

1. Edit Your Variable Product
   • Go to Products → All Products in your WordPress admin.
   • Click Edit on the desired variable product.
2. Open the Variations Tab
   • In the Product Data panel, select the Variations tab.
   • Expand a specific variation by clicking the Edit button.
3. Locate the Price Breakup Section
   • Scroll down within the variation settings until you see the Price Breakup section.
   • This section allows you to assign materials and diamonds individually for that specific variation.
4. Add Materials
   • Choose a Material Type from the dropdown (these are predefined in your Materials settings).
   • Enter the Weight (in grams), Making Cost, and Making Sale Cost for that material.
   • Click Add Material if you want to include multiple material components.
5. Add Diamonds
   • Enter diamond details such as Name, Color, Shape, Weight (in carats), Price per Carat, and Sale Price per Carat.
   • Click Add Diamond to include multiple diamonds for the variation.
6. Save the Variation
   • Once all material and diamond details are filled, click Save Changes to store the configuration for that variation.

Each variation can have its own unique combination of materials and diamonds. This ensures that the product price is accurately calculated based on the selected variation, providing your customers with a clear and transparent price structure.

Shortcode

↑ Back to top

ou can display the Jewellery Price Table for any product using the [JPWC_Table] shortcode.

[JPWC_Table product_id="1554"]

This will display the price table for the product with ID 1554 using the default table style.

Optional: Table Style
You can customize the look of the table using the table_style attribute. Available styles are:

• style-default → Custom
• style-modern → Modern
• elegant-table → Elegant
• style-luxury → Luxury
• style-royal → Royal
• style-regal → Regal
• style-minimal → Minimal

Examples:

[JPWC_Table product_id="1554" table_style="style-modern"]
[JPWC_Table product_id="1554" table_style="style-royal"]
[JPWC_Table product_id="1554" table_style="style-minimal"]

Notes:

• product_id is required — use the actual product’s ID.
• table_style is optional — if not set, the default style will be used.
• The shortcode can be placed in product descriptions, pages, posts, widgets, or builder modules that support shortcodes.

Hooks and Filters

↑ Back to top

jpwc_calculated_product_taxes

Customize or modify the tax breakdown calculated for a WooCommerce product.

Usage:

add_filter( 'jpwc_calculated_product_taxes', 'my_custom_tax_logic', 10, 3 );

function my_custom_tax_logic( $taxes, $product, $netAmount ) {
    // Modify or add tax rows here
    return $taxes;
}

Parameters:

• $taxes (array) – Array of calculated tax items.
• $product (WC_Product) – The WooCommerce product object.
• $netAmount (float) – The product’s net price.

jpwc_get_diamond_price

Modify the final diamond price calculation per carat.

Usage:

add_filter( 'jpwc_get_diamond_price', 'my_custom_diamond_price', 10, 2 );

function my_custom_diamond_price( $price, $diamond ) {
    // Apply discounts or override logic
    return $price;
}

Parameters:

• $price (float) – The final calculated price.
• $diamond (array) – Diamond data array (must include _weight, _carat_price, etc.).

jpwc_get_making_price

Override or modify the final making charge for a material.

Usage:

add_filter( 'jpwc_get_making_price', 'my_custom_making_price', 10, 2 );

function my_custom_making_price( $price, $material ) {
    // Customize the making charge here
    return $price;
}

Parameters:

• $price (float) – Final making price (sale or regular).
• $material (array) – Material data array containing _making_price, _making_sale_price, etc.

jpwc_table_args

Customize the data passed to the table template renderer.

Usage:

add_filter( 'jpwc_table_args', 'modify_table_args', 10, 1 );

function modify_table_args( $args ) {
    // Add or modify data passed to the template
    return $args;
}

Parameters:

• $args(array) – Array containing:
  • 'options' – Plugin settings.
  • 'style' – Selected style.
  • 'data' – Product calculation data.

jpwc_material_type_option

Customize or extend the list of available material types (e.g. Gold 24K, Silver).

Usage:

add_filter( 'jpwc_material_type_option', 'custom_material_types' );

function custom_material_types( $types ) {
    $types['RHODIUM'] = 'Rhodium';
    return $types;
}

Parameters:

• $types (array) – List of material type keys and labels.

jpwc_get_single_hooks_option

Modify the available WooCommerce hook locations for auto-inserting the price table.

Usage:

add_filter( 'jpwc_get_single_hooks_option', 'custom_hook_positions' );

function custom_hook_positions( $hooks ) {
    // Add a custom hook group or location
    $hooks['custom']['my_custom_hook-0'] = 'My Custom Hook';
    return $hooks;
}

Parameters:

• $hooks (array) – Array of grouped hook locations (e.g., default, astra) with position keys and labels.

FAQs

↑ Back to top