replace INTO cataloginventory_stock_item (
item_id,
product_id,
stock_id,
qty,
min_qty,
use_config_min_qty,
is_qty_decimal,
backorders,
use_config_backorders,
min_sale_qty,
use_config_min_sale_qty,
max_sale_qty,
use_config_max_sale_qty,
is_in_stock,
low_stock_date,
notify_stock_qty,
use_config_notify_stock_qty,
manage_stock,
use_config_manage_stock,
stock_status_changed_auto,
use_config_qty_increments,
qty_increments,
use_config_enable_qty_inc,
enable_qty_increments
) VALUES (
NULL, 
<@KEY@>,
1,
<@NEWFQTYONHAND@> / <@UNITQTY@>,
'0',
1,
0,
0,
1,
'1',
1,
'0',
1,
1,
now(),
NULL,
1,
0,
1,
1,
1,
'0',
1,
0
);
@@GO@@
replace INTO cataloginventory_stock_status (
product_id,
website_id,
stock_id,
qty,
stock_status
) VALUES (
<@KEY@>,
1,
1,
<@NEWFQTYONHAND@> / <@UNITQTY@>,
1);
@@GO@@
replace INTO catalogsearch_fulltext (
fulltext_id,
product_id,
store_id,
data_index
) VALUES (
NULL,
<@KEY@>,
1,
CONCAT('<@SSTOCKCODE@>',
    '|Enabled|',
    'Taxable Goods',
    '|',
    '<@SDESCRIPTION@>',
    '|',
    '<@SDESCRIPTION@>',
    '|',
    '<@SDESCRIPTION@>',
    '|',
    '<@FSELLINGPRICE1@>',
    '|0')
);
@@GO@@

replace INTO `catalog_product_index_price` (`entity_id`, `customer_group_id`, `website_id`, `tax_class_id`, `price`, `final_price`, `min_price`, `max_price`, `tier_price`) VALUES 
(<@KEY@>, 0, 1, 1, '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', NULL),
(<@KEY@>, 1, 1, 1, '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', NULL),
(<@KEY@>, 2, 1, 1, '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', NULL),
(<@KEY@>, 3, 1, 1, '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', '<@FSELLINGPRICE1@>', NULL);
@@GO@@