On the test database, delete the records in all the tables except the wa_settings table. this table should not be included in the export.
also not included in the export are the tables that have names beginning with kfm.
for the pricce:
on the webassist/plugins/catalog/details.php page, change lines 61 - 64:
php:
<span class="price">
<span class="ProductPrice">Price: <?php echo($WAGLOBAL_CurrencySymbol); ?><span id="ProductPrice"><?php echo number_format($row_WADAProducts["ProductPrice"], 2); ?></span></span>
<span id="retailRow" class="ProductRetailPrice errorText" <?php echo((!empty($row_WADAProducts["ProductRetailPrice"]) && $row_WADAProducts["ProductRetailPrice"] > $row_WADAProducts["ProductPrice"])?' style="display:block"':' style="display:none"'); ?>>Retail Price: <?php echo($WAGLOBAL_CurrencySymbol); ?><span id="ProductRetailPrice" class="strike"><?php echo number_format($row_WADAProducts["ProductRetailPrice"], 2); ?></span> (Save <?php echo($WAGLOBAL_CurrencySymbol); ?><span id="ProductRetailPriceSave"><?php echo number_format(floatval($row_WADAProducts["ProductRetailPrice"]) - floatval($row_WADAProducts["ProductPrice"]), 2); ?></span>)</span>
</span>
to:
php:
<span class="price">
<?php if(!($row_NumLeftRS["NumLeft"] == 0 && $row_WADAProducts["ProductLive"] != 0 && $row_WADAProducts["ProductUnlimited"] == 0)) { ?><span class="ProductPrice">Price: <?php echo($WAGLOBAL_CurrencySymbol); ?><span id="ProductPrice"><?php echo number_format($row_WADAProducts["ProductPrice"], 2); ?></span></span>
<span id="retailRow" class="ProductRetailPrice errorText" <?php echo((!empty($row_WADAProducts["ProductRetailPrice"]) && $row_WADAProducts["ProductRetailPrice"] > $row_WADAProducts["ProductPrice"])?' style="display:block"':' style="display:none"'); ?>>Retail Price: <?php echo($WAGLOBAL_CurrencySymbol); ?><span id="ProductRetailPrice" class="strike"><?php echo number_format($row_WADAProducts["ProductRetailPrice"], 2); ?></span> (Save <?php echo($WAGLOBAL_CurrencySymbol); ?><span id="ProductRetailPriceSave"><?php echo number_format(floatval($row_WADAProducts["ProductRetailPrice"]) - floatval($row_WADAProducts["ProductPrice"]), 2); ?></span>)</span>
<?php } ?> </span>
