Samples > Data load utility samples
Sample: Loading list prices in multiple currencies
This sample demonstrates how to load list prices in multiple national currencies simultaneously. You can load different national currencies to the store by modifying the source file in the sample. All currency codes are based on the ISO 4217 standard.
About this sample
The following currencies are loaded in this sample:
- United States dollar (USD)
- Canadian dollar (CAD)
- euro (EUR)
Procedure
- Open the command-line interface, and navigate to the appropriate directory:
- WC_INSTALL/bin
- WCDE_INSTALL\bin
- Enter the following command:
- ./dataload.sh ../samples/DataLoad/Catalog/MultiListPrices/wc-dataload.xml
- dataload ..\samples\DataLoad\Catalog\MultiListPrices\wc-dataload.xml
Verify results
The wc-dataload.xml configuration file calls the wc-loader-catalog-entry.xml configuration file to load product, SKU, and list price information from the CatalogEntries.csv source file, located in the same directory. Three list prices are created for each catalog entry. The default currency is USD. The alternate currencies are loaded from the AlternativeCurrency1 and AlternativeCurrency2 columns in the CSV file. The alternate list price values are loaded from the AlternativeListPrice1 and AlternativeListPrice2 columns in the CSV file.Verify that the data has been loaded by running the following SQL statements:
- To return the multiple list prices created for the product and SKU, enter:
select * from listprice where catentry_id in (select catentry_id from catentry where partnumber like 'Cords%')
You can also verify the load by viewing the currencies in the Management Center or in the storefront.
Clean up the data
To remove the data loaded in this sample from the database, run the CleanUp.sql file in the /samples/DataLoad/Catalog/MultiListPrices directory.
Previous topic: Sample: Loading data to an extended sites store and catalog asset store
Next topic: Inventory samples
Related reference