\/****** Object: StoredProcedure [dbo].[generate_price_calculation_data] Script Date: 2020-06-19 10:15:42 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nremove-this-phrase– =============================================
\nremove-this-phrase– Author: <Author,,Name>
\nremove-this-phrase– Create date: <Create Date,,>
\nremove-this-phrase– Description:\t<Description,,>
\nremove-this-phrase– =============================================
\nCREATE PROCEDURE [dbo].[generate_price_calculation_data]
\nAS
\nBEGIN
\nremove-this-phrase– Visibility status
\nSELECT [Product ID] as product_id
\n,[Model Code] as sku
\n,[Full Product Name] as [Name]
\n, as _category
\n, ‘All’ as _root_category
\n,[1pc Price] as raw_price
\n,[1pc Cheapest Postal Shipping Price] as dummy
\n,[1pc Cheapest Express Courier Shipping Price] as cheapest_courier_shipping
\n,[EAN] as product_ean
\nremove-this-phrase–Ship Risk\tPrice Risk\tTotal\tRisk Return Total with ship\tReferral Fee\tPaypal Fees\tFinal Value Fee\tInsertion Fee HST\tEU Vat\tCurrency Risk\tshopforsoul_profit\tebay_profit\tIncome Tax\tshopforsoul_cost\tMLP\tSpecial List Price\tspecial_from_date\tspecial_to_date\tebay_cost\tebay_list_price\tBuyer pay from Mall\tEay Buyers Pay\tEbay vs Mall\tNA-1\tAmazon Final Value Fee\tamazon_profit\tamazon_our_cost\tamazon_list_price\tamazon_special_price\tAmazon Final Value Fee USD\tamazon_profit_usd\tamazon_our_cost_usd\tamazon_list_price_usd\tamazon_special_price_usd\tamazon_list_price_gbp\tamazon_special_price_gbp\tamazon_list_price_eu\tamazon_special_price_eu\tamazon_list_price_mxn\tamazon_special_price_mxn\tama_safe_refund_amount
\n,ROUND([1pc Cheapest Express Courier Shipping Price]*0.03,2) as ship_risk
\n,ROUND([1pc Price]*0.03,2) as price_risk
\nremove-this-phrase–,ROUND([1pc Price]+G2+I2+J2,2) as total
\n,ROUND([1pc Cheapest Express Courier Shipping Price]*0.2,2) as risk_return
\nremove-this-phrase–,ROUND(K2+L2;2) as total_with_shipping
\nremove-this-phrase–,ROUND(M2*0.1;2) as referral_fee
\nremove-this-phrase–,ROUND(0.3+M2*0.03;2) as paypal_fees
\nremove-this-phrase–,ROUND(M2*0.07;2) as final_value_fees
\nremove-this-phrase–,ROUND(M2*0.01;2) as insertion_fees
\nremove-this-phrase–,ROUND(M2*0.13;2) as HST
\nremove-this-phrase–,ROUND(M2*0.25;2) as eu_vat
\nremove-this-phrase– amazon_ca_minimum_price\tamazon_usd_minimum_price\tamazon_gbp_minimum_price\tamazon_eu_minimum_price\tamazon_mxn_minimum\tamazon_ca_abs_minimum\texpedited_cost
\n,[Soon Discontinued]
\n,[Weight Kg] * 2.2 as Weight
\n,[Height mm] as Height
\n,[Width mm] as Width
\n,[Depth mm] as Depth
\n,[Retail Price] as Retail_price
\n,[Stock status] as "Stock status"
\n,[Date Back]
\nremove-this-phrase–Weight right\tShip Right\tIs Normal
\nFROM [DealWithAmazonShopForSoul].[dbo].[supplier-data-jan-01-2019]
\nEND
\nGO
\n*** . *** *** . *** . *** . ***<\/p>\n
Training Courses: <\/strong>http:\/\/Training.SitesTree.com<\/a> <\/em> <\/em> Facebook Groups\/Forums to discuss (Q & A): <\/strong><\/em> https:\/\/www.facebook.com\/banglasalearningschool<\/a> Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. <\/em>http:\/\/sitestree.com\/training\/<\/a><\/p>\n Join, Discuss, and Thrive:<\/strong> Bangladesh and Canada: https:\/\/www.facebook.com\/groups\/398414183875009<\/a><\/p>\n Bangladesh: IT & Eng: Canada: https:\/\/www.facebook.com\/groups\/480297675634630<\/a><\/p>\n BUETians in Ontario: https:\/\/www.facebook.com\/groups\/371982239854027<\/a><\/p>\n Worldwide IT: https:\/\/www.facebook.com\/groups\/28362061867<\/a><\/p>\n
\nBlog<\/strong>: http:\/\/Bangla.SaLearningSchool.com<\/a>, http:\/\/SitesTree.com<\/a><\/em>
\n8112223 Canada Inc\/Justetc<\/strong>: http:\/\/JustEtc.net<\/a><\/em>
\nYoutube: <\/em>https:\/\/www.youtube.com\/channel\/UCHrtq0pV8mEuTLGd2-Lp9ig\/playlists<\/a>
\nMedium: <\/strong><\/em>https:\/\/medium.com\/@SayedAhmedCanada<\/a><\/p>\n
\nSayed Ahmed<\/strong>
\n<\/em>
\nBSc. Eng. in Comp. Sc. & Eng. (BUET)<\/strong><\/em>
\nMSc. in Comp. Sc. (U of Manitoba, Canada)<\/strong><\/em>
\nMSc. in Data Science and Analytics (Ryerson University, Canada)<\/strong><\/em>
\nLinkedin<\/strong>: https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a>
\n<\/em><\/p>\n
\nhttps:\/\/www.facebook.com\/salearningschool<\/a><\/p>\n
\nhttps:\/\/www.facebook.com\/justetcsocial<\/a><\/p>\n
\nFinance: https:\/\/www.facebook.com\/groups\/1792339521056034<\/a><\/p>\n