bf error diff2_10 on calculation

1 files changed, 550 insertions, 104 deletions

diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr
index eac6ff3..36bf708 100644
--- a/calculate_price_after_disc.ktr
+++ b/calculate_price_after_disc.ktr
@@ -493,16 +493,6 @@
       <enabled>Y</enabled>
     </hop>
     <hop>
-      <from>calculate diff</from>
-      <to>calculate discount</to>
-      <enabled>Y</enabled>
-    </hop>
-    <hop>
-      <from>calculate discount</from>
-      <to>dw Insert / update calc pl</to>
-      <enabled>Y</enabled>
-    </hop>
-    <hop>
       <from>Table input</from>
       <to>Filter rows</to>
       <enabled>Y</enabled>
@@ -522,6 +512,16 @@
       <to>calculate price tier</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>calculate diff</from>
+      <to>calculate discount</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>calculate discount</from>
+      <to>dw Insert / update calc pl</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -738,7 +738,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -761,7 +761,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -784,7 +784,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -807,7 +807,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -830,7 +830,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -853,7 +853,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -876,7 +876,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -899,7 +899,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -922,7 +922,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -945,7 +945,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -968,7 +968,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -991,7 +991,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1014,7 +1014,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1037,7 +1037,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1060,7 +1060,53 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_std9</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_std9</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_std10</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_std10</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1083,7 +1129,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1106,7 +1152,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1129,7 +1175,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1152,7 +1198,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1175,7 +1221,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1198,7 +1244,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1221,7 +1267,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1244,7 +1290,53 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_group9</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_group9</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_group10</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_group10</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1267,7 +1359,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1290,7 +1382,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1313,7 +1405,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1336,7 +1428,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1359,7 +1451,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1382,7 +1474,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1405,7 +1497,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1428,7 +1520,53 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_tier2_9</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_tier2_9</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_tier2_10</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_tier2_10</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1451,7 +1589,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1474,7 +1612,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1497,7 +1635,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1520,7 +1658,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1543,7 +1681,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1566,7 +1704,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1589,7 +1727,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1612,7 +1750,53 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_tier3_9</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_tier3_9</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_tier3_10</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_tier3_10</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1635,7 +1819,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1658,7 +1842,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1681,7 +1865,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1704,7 +1888,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1727,7 +1911,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1750,7 +1934,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1773,7 +1957,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1796,7 +1980,53 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_tier4_9</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_tier4_9</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_tier4_10</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_tier4_10</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1819,7 +2049,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1842,7 +2072,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1865,7 +2095,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1888,7 +2118,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1911,7 +2141,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1934,7 +2164,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1957,7 +2187,7 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -1980,7 +2210,53 @@ left join brand b on b.id = p.brand_id</sql>
         <sort_descending>N</sort_descending>
         <output_padding>N</output_padding>
         <date_format_lenient>N</date_format_lenient>
-        <date_format_locale>en_ID</date_format_locale>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_tier5_9</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_tier5_9</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
+        <date_format_timezone>Asia/Bangkok</date_format_timezone>
+        <lenient_string_to_number>N</lenient_string_to_number>
+      </value-meta>
+      <value-meta>
+        <type>BigNumber</type>
+        <storagetype>normal</storagetype>
+        <name>markup_tier5_10</name>
+        <length>-1</length>
+        <precision>-1</precision>
+        <origin>Table input</origin>
+        <comments>markup_tier5_10</comments>
+        <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask>
+        <decimal_symbol>.</decimal_symbol>
+        <grouping_symbol/>
+        <currency_symbol/>
+        <trim_type>none</trim_type>
+        <case_insensitive>N</case_insensitive>
+        <collator_disabled>Y</collator_disabled>
+        <collator_strength>0</collator_strength>
+        <sort_descending>N</sort_descending>
+        <output_padding>N</output_padding>
+        <date_format_lenient>N</date_format_lenient>
+        <date_format_locale>en_US</date_format_locale>
         <date_format_timezone>Asia/Bangkok</date_format_timezone>
         <lenient_string_to_number>N</lenient_string_to_number>
       </value-meta>
@@ -2027,6 +2303,21 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
+      <field_name>diff1_10</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc10</field_a>
+      <field_b>price_after_disc_10</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
       <field_name>diff1_2</field_name>
       <calc_type>SUBTRACT</calc_type>
       <field_a>price_before_disc2</field_a>
@@ -2147,10 +2438,10 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>diff1_10</field_name>
+      <field_name>diff2_1</field_name>
       <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc10</field_a>
-      <field_b>price_after_disc_10</field_b>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_tier2_1</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -2162,10 +2453,10 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>diff2_1</field_name>
+      <field_name>diff2_10</field_name>
       <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc1</field_a>
-      <field_b>price_tier2_1</field_b>
+      <field_a>price_before_disc10</field_a>
+      <field_b>price_tier2_10</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -2297,10 +2588,10 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>diff3_10</field_name>
+      <field_name>diff3_1</field_name>
       <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc10</field_a>
-      <field_b>price_tier2_10</field_b>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_tier3_1</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -2312,10 +2603,10 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>diff3_1</field_name>
+      <field_name>diff3_10</field_name>
       <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc1</field_a>
-      <field_b>price_tier3_1</field_b>
+      <field_a>price_before_disc10</field_a>
+      <field_b>price_tier3_10</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -2447,10 +2738,10 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>diff3_10</field_name>
+      <field_name>diff4_1</field_name>
       <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc10</field_a>
-      <field_b>price_tier3_10</field_b>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_tier4_1</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -2462,10 +2753,10 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>diff4_1</field_name>
+      <field_name>diff4_10</field_name>
       <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc1</field_a>
-      <field_b>price_tier4_1</field_b>
+      <field_a>price_before_disc10</field_a>
+      <field_b>price_tier4_10</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -2597,10 +2888,10 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>diff4_10</field_name>
+      <field_name>diff5_1</field_name>
       <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc10</field_a>
-      <field_b>price_tier4_10</field_b>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_tier5_1</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -2612,10 +2903,10 @@ left join brand b on b.id = p.brand_id</sql>
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>diff5_1</field_name>
+      <field_name>diff5_10</field_name>
       <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc1</field_a>
-      <field_b>price_tier5_1</field_b>
+      <field_a>price_before_disc10</field_a>
+      <field_b>price_tier5_10</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -2746,21 +3037,6 @@ left join brand b on b.id = p.brand_id</sql>
       <grouping_symbol/>
       <currency_symbol/>
     </calculation>
-    <calculation>
-      <field_name>diff5_10</field_name>
-      <calc_type>SUBTRACT</calc_type>
-      <field_a>price_before_disc10</field_a>
-      <field_b>price_tier5_10</field_b>
-      <field_c/>
-      <value_type>None</value_type>
-      <value_length>-1</value_length>
-      <value_precision>-1</value_precision>
-      <remove>N</remove>
-      <conversion_mask/>
-      <decimal_symbol/>
-      <grouping_symbol/>
-      <currency_symbol/>
-    </calculation>
     <attributes/>
     <cluster_schema/>
     <remotesteps>
@@ -5464,6 +5740,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>disc1_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc1_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>disc2_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5504,6 +5790,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>disc2_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc2_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>disc3_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5544,6 +5840,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>disc3_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc3_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>disc4_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5584,6 +5890,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>disc4_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc4_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>disc5_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5624,6 +5940,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>disc5_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc5_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>item_code</name>
         <rename>item_code</rename>
         <update>Y</update>
@@ -5669,6 +5995,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>markup_group9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>markup_std1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5709,6 +6045,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>markup_std9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>markup_tier2_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5749,6 +6095,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>markup_tier2_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>markup_tier3_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5789,6 +6145,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>markup_tier3_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>markup_tier4_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5829,6 +6195,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>markup_tier4_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier4_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>markup_tier5_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5869,6 +6245,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>markup_tier5_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier5_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>name</name>
         <rename>name</rename>
         <update>Y</update>
@@ -5914,6 +6300,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>price_after_disc_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>price_before_disc1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5954,6 +6350,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>price_before_disc9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>price_tier2_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -5994,6 +6400,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>price_tier2_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>price_tier3_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -6034,6 +6450,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>price_tier3_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>price_tier4_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -6074,6 +6500,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>price_tier4_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>price_tier5_1</name>
         <rename>zero</rename>
         <update>Y</update>
@@ -6114,6 +6550,16 @@ left join brand b on b.id = p.brand_id</sql>
         <update>Y</update>
       </value>
       <value>
+        <name>price_tier5_9</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_10</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
         <name>pricing_group</name>
         <rename>pricing_group</rename>
         <update>Y</update>