Creating inventory adjustment codes

To add inventory adjustment codes for your store:

  1. Create an XML file (with a name of your choice) similar to the following example, and place it in a location where the Loader can find it. In the XML file, specify values for the invadjcode and invadjdesc elements to add the new inventory adjustment code to two database tables: INVADJCODE and INVADJDESC table. The invadjcode_id should be the same value in both tables for any given code.
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE import SYSTEM "wcs.dtd">
    <import>
    <invadjcode invadjcode_id="404" adjustcode="BRKN" storeent_id="-1" markfordelete="0" />
    <invadjdesc invadjcode_id="404" description="BROKEN" language_id="-1" />
    </import>
    

    where:

    invadjcode_id
    is an adjustment code identifier you assign. The identifier is used internally and is not displayed to users in the WebSphere Commerce user interface.
    adjustcode
    is a 4-character code that uniquely identifies the code, suitable for display in a user interface.
    storeent_id
    is the identifier for the store entity or store group. To add this inventory adjustment code to all stores, enter a value of "-1". Otherwise, provide a specific store entity or store group identifier.
    description
    is a text description of the inventory adjustment code, suitable for display in a user interface.
    language_id
    is the default language for information displayed to customers shopping in the store.

    If you have a need to add more than one inventory adjustment code, you can specify multiple codes in the XML file.

  2. Run the Load command against your XML file to load your data into the target database.

    Windows

    massload.cmd -dbname dbname -dbuser dbuser -dbpwd dbpwd -infile 
    xml_file_name -method sqlimport 
    

    AIXSun Solaris Operating EnvironmentLinux Become wasuser first (the WebSphere Application Server user ID):

    su - wasuser
    

    Then, issue this command:

    ./massload.sh -dbname dbname -dbuser dbuser -dbpwd dbpwd -infile 
    xml_file_name -method sqlimport 
    

    i5/OSiSeries Start a QShell session (STRQSH). Then, run the following command from the WC_installdir/bin directory:

    massload.sh -dbname dbname 
    -dbuser dbuser -dbpwd dbpwd -infile 
    xml_file_name -method sqlimport
    
  3. Confirm the addition of the inventory adjustment codes by running a database query to view the new code values were added to both tables.

Feedback