The outcome of this SQL should be a list with the proper. Only the first columns are relevant.Īfter that is done, run the following SQL script: selectĬoncat('RewriteRule ^product/', sm.keyword, ' ', 'index.php?route=product/product&product_id=', prod.product_id) as url_rewrite Upload the Excel with your DBA software to the MySQL database where Opencart is located. Upload Excel document to Opencart located database GetNumericFromString = Strings.StrReverse(Result) If IsNumeric(StringValue) And hasStopped = False Then We require only 2 columns:ĭisclaimerI am not an experienced VBA developer, so don't be to critical on the following code.įunction GetNumericFromString(CellRef As String) I imported the sitemap.xml from Woocommerce into Excel. The first segment (^product/.) is the Woocommerce part and the second segment is the Opencart (index.php?route.) Condition with an to make these rules only valid from some of the stores (domains) RewriteRule ^product/batterijbox-zie-led-uv-lamp-770624-370689 index.php?route=product/product&product_id=110 RewriteRule ^product/9v-battery-box-370689 index.php?route=product/product&product_id=110 RewriteRule ^product/iq-2-positioner-880302 index.php?route=product/product&product_id=111 In that case you have to write a modification (OCMOD or VCMOD). So this solution requires a different approach if you have lots (1000+) of products. In case of our customer's store, it were less than 1000 products. We don't want to change the source code or write a VQMOD or OCMOD for this Using.
0 Comments
Leave a Reply. |