USE [AmazonShopForSoul]
\nGO
\n\/****** Object: StoredProcedure [dbo].[auto_pricing_data_for_germany] Script Date: 2020-06-19 10:16:30 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO<\/p>\n
remove-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].[auto_pricing_data_for_germany]
\nAS
\nBEGIN
\nremove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from
\nremove-this-phrase– interfering with SELECT statements.
\nSET NOCOUNT ON;<\/p>\n
\/*
\nselect p.sku, round(amazon_special_price_eu,2) as price, round(amazon_eu_minimum_price,2) as [minimum-seller-allowed-price]
\n, round(amazon_list_price_eu,2) as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time], ‘default’ as [fulfillment-channel], germany.asin
\nfrom price_calculations p
\ninner join [germany-Inventory+Report+07-03-2018] germany on germany.sku=p.sku
\n*\/<\/p>\n
remove-this-phrase–no more required
\n\/*
\nselect p.sku, round(amazon_special_price_eu,2) as price, round(amazon_eu_minimum_price,2) as [minimum-seller-allowed-price]
\n, round(amazon_list_price_eu,2) as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time], ‘default’ as [fulfillment-channel], germany.asin
\nfrom price_calculations_jul_11_2018 p
\ninner join [GermanyInventoryReport07132018] germany on germany.sku=p.sku
\n*\/<\/p>\n
\/*fix null price*\/
\nselect * from GermanyAllListingsReport07182018
\nwhere price is null<\/p>\n
update
\nGermanyAllListingsReport07182018
\nset price=0.01
\nwhere price is null<\/p>\n
remove-this-phrase–product that should be on amazon
\nselect p.sku, REPLACE (round(amazon_special_price_eu,2), ‘.’, ‘,’) as price
\n, REPLACE (round(amazon_eu_minimum_price,2), ‘.’, ‘,’) as [minimum-seller-allowed-price]
\n, REPLACE (round(amazon_list_price_eu,2), ‘.’, ‘,’) as [maximum-seller-allowed-price], 1 as quantity, 4 as [handling-time]
\n, ‘default’ as [fulfillment-channel]
\nfrom price_calculations_jul_17_2018 p
\ninner join GermanyAllListingsReport07182018 germany on germany.[seller-sku]=p.sku
\nwhere (germany.status=’Active’) and (p.status=1)<\/p>\n
remove-this-phrase–remove-this-phrase–out of stock or disabled or incomplete or soon discontinued
\nselect p.sku, REPLACE (round(amazon_special_price_eu,2), ‘.’, ‘,’) as price
\n, REPLACE (round(amazon_eu_minimum_price,2), ‘.’, ‘,’) as [minimum-seller-allowed-price]
\n, REPLACE (round(amazon_list_price_eu,2), ‘.’, ‘,’) as [maximum-seller-allowed-price]
\n, 0 as quantity, 4 as [handling-time]
\n, ‘default’ as [fulfillment-channel]
\nfrom price_calculations_jul_17_2018 p
\ninner join GermanyAllListingsReport07182018 germany on germany.[seller-sku]=p.sku
\nwhere (p.status=2)<\/p>\n
remove-this-phrase–not in our current supplier inventory
\nremove-this-phrase–but on our Amazon inventory
\nselect germany.[seller-sku] as sku, 0 as quantity
\n, replace(germany.price,’.’,’,’) as price, germany.asin1 as asinremove-this-phrase–, germany.[item-name]
\nfrom GermanyAllListingsReport07182018 germany remove-this-phrase–price_calculations_jul_17_2018 p
\nwhere germany.[seller-sku] not in (select sku from price_calculations_jul_17_2018)<\/p>\n
END
\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