/****** Object: StoredProcedure [dbo].[generate_price_calculation_data] Script Date: 2020-06-19 10:15:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
remove-this-phrase– =============================================
remove-this-phrase– Author: <Author,,Name>
remove-this-phrase– Create date: <Create Date,,>
remove-this-phrase– Description: <Description,,>
remove-this-phrase– =============================================
CREATE PROCEDURE [dbo].[generate_price_calculation_data]
AS
BEGIN
remove-this-phrase– Visibility status
SELECT [Product ID] as product_id
,[Model Code] as sku
,[Full Product Name] as [Name]
, as _category
, ‘All’ as _root_category
,[1pc Price] as raw_price
,[1pc Cheapest Postal Shipping Price] as dummy
,[1pc Cheapest Express Courier Shipping Price] as cheapest_courier_shipping
,[EAN] as product_ean
remove-this-phrase–Ship Risk Price Risk Total Risk Return Total with ship Referral Fee Paypal Fees Final Value Fee Insertion Fee HST EU Vat Currency Risk shopforsoul_profit ebay_profit Income Tax shopforsoul_cost MLP Special List Price special_from_date special_to_date ebay_cost ebay_list_price Buyer pay from Mall Eay Buyers Pay Ebay vs Mall NA-1 Amazon Final Value Fee amazon_profit amazon_our_cost amazon_list_price amazon_special_price Amazon Final Value Fee USD amazon_profit_usd amazon_our_cost_usd amazon_list_price_usd amazon_special_price_usd amazon_list_price_gbp amazon_special_price_gbp amazon_list_price_eu amazon_special_price_eu amazon_list_price_mxn amazon_special_price_mxn ama_safe_refund_amount
,ROUND([1pc Cheapest Express Courier Shipping Price]*0.03,2) as ship_risk
,ROUND([1pc Price]*0.03,2) as price_risk
remove-this-phrase–,ROUND([1pc Price]+G2+I2+J2,2) as total
,ROUND([1pc Cheapest Express Courier Shipping Price]*0.2,2) as risk_return
remove-this-phrase–,ROUND(K2+L2;2) as total_with_shipping
remove-this-phrase–,ROUND(M2*0.1;2) as referral_fee
remove-this-phrase–,ROUND(0.3+M2*0.03;2) as paypal_fees
remove-this-phrase–,ROUND(M2*0.07;2) as final_value_fees
remove-this-phrase–,ROUND(M2*0.01;2) as insertion_fees
remove-this-phrase–,ROUND(M2*0.13;2) as HST
remove-this-phrase–,ROUND(M2*0.25;2) as eu_vat
remove-this-phrase– amazon_ca_minimum_price amazon_usd_minimum_price amazon_gbp_minimum_price amazon_eu_minimum_price amazon_mxn_minimum amazon_ca_abs_minimum expedited_cost
,[Soon Discontinued]
,[Weight Kg] * 2.2 as Weight
,[Height mm] as Height
,[Width mm] as Width
,[Depth mm] as Depth
,[Retail Price] as Retail_price
,[Stock status] as "Stock status"
,[Date Back]
remove-this-phrase–Weight right Ship Right Is Normal
FROM [DealWithAmazonShopForSoul].[dbo].[supplier-data-jan-01-2019]
END
GO
*** . *** *** . *** . *** . ***
Training Courses: http://Training.SitesTree.com
Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
8112223 Canada Inc/Justetc: http://JustEtc.net
Youtube: https://www.youtube.com/channel/UCHrtq0pV8mEuTLGd2-Lp9ig/playlists
Medium: https://medium.com/@SayedAhmedCanada
Sayed Ahmed
BSc. Eng. in Comp. Sc. & Eng. (BUET)
MSc. in Comp. Sc. (U of Manitoba, Canada)
MSc. in Data Science and Analytics (Ryerson University, Canada)
Linkedin: https://ca.linkedin.com/in/sayedjustetc
Facebook Groups/Forums to discuss (Q & A):
https://www.facebook.com/salearningschool
https://www.facebook.com/banglasalearningschool
https://www.facebook.com/justetcsocial
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. http://sitestree.com/training/
Join, Discuss, and Thrive:
Finance: https://www.facebook.com/groups/1792339521056034
Bangladesh and Canada: https://www.facebook.com/groups/398414183875009
Bangladesh: IT & Eng: Canada: https://www.facebook.com/groups/480297675634630
BUETians in Ontario: https://www.facebook.com/groups/371982239854027
Worldwide IT: https://www.facebook.com/groups/28362061867
JustEtc: https://www.facebook.com/JustETC-Technologies-Inc-289864738261
