/****** Object: StoredProcedure [dbo].[xls_auto_pricing_data_for_Uk_eu] 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].[xls_auto_pricing_data_for_Uk_eu]
AS
BEGIN
remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from
remove-this-phrase– interfering with SELECT statements.
SET NOCOUNT ON;
update july_22nd_2019__price_calculations
set sku=concat(‘shopforsoul-‘, sku)
where sku not like ‘%shopfor%’;
remove-this-phrase–select * from CanadaAllListingsReport12252018;
remove-this-phrase–minimum price update
select trim(uk.[seller-sku]) as sku
remove-this-phrase–select trim(canada.[seller_sku]) as sku
remove-this-phrase–,p.sku
remove-this-phrase–,trim(concat(‘shopforsoul-‘,s.[Model Code]))
, round(amazon_special_price_gbp + 6, 2) as price
, round(amazon_gbp_minimum_price + 6, 2) as [minimum-seller-allowed-price]
, round(amazon_list_price_gbp + 6 ,2) as [maximum-seller-allowed-price]
, 1 as quantity
, 10 as [handling-time]
, ‘default’ as [fulfillment-channel]
remove-this-phrase–, s.[Stock status]
from july_22nd_2019__price_calculations p
inner join UkAllListingsReport08262019 uk on trim(uk.[seller-sku])=trim(p.sku)
remove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
remove-this-phrase–inner join [supplier-jan-10-2019] s on trim(concat(‘shopforsoul-‘,s.[Model Code]))=trim(p.sku)
where (uk.status=’Active’) and (p.status=1)
remove-this-phrase–and s.[Stock status] = ‘In Stock’
remove-this-phrase–and sku like ‘%shopforsoul-PTO_03FTX3%’
remove-this-phrase–#FranceAllListingsReport02272019
remove-this-phrase–minimum price update
select fr.[seller-sku] as sku
remove-this-phrase–select trim(canada.[seller_sku]) as sku
remove-this-phrase–,p.sku
remove-this-phrase–,trim(concat(‘shopforsoul-‘,s.[Model Code]))
, round(amazon_special_price_eu + 6, 2) as price
, round(amazon_eu_minimum_price + 6, 2) as [minimum-seller-allowed-price]
, round(amazon_list_price_eu + 6 ,2) as [maximum-seller-allowed-price]
, 1 as quantity
, 10 as [handling-time]
, ‘default’ as [fulfillment-channel]
remove-this-phrase–, s.[Stock status]
from july_22nd_2019__price_calculations p
inner join SpainAllListingsReport08262019 fr on fr.[seller-sku]=trim(p.sku)
remove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
remove-this-phrase–inner join [supplier-jan-10-2019] s on trim(concat(‘shopforsoul-‘,s.[Model Code]))=trim(p.sku)
where (fr.status=’Active’) and (p.status=1) and (fr.[seller-sku] like ‘%shopforsoul%’)
remove-this-phrase–and s.[Stock status] = ‘In Stock’
remove-this-phrase–and sku like ‘%shopforsoul-PTO_03FTX3%’
remove-this-phrase—
remove-this-phrase–#spain
remove-this-phrase–minimum price update
select trim(sp.[seller_sku]) as sku
remove-this-phrase–select trim(canada.[seller_sku]) as sku
remove-this-phrase–,p.sku
remove-this-phrase–,trim(concat(‘shopforsoul-‘,s.[Model Code]))
, round(amazon_special_price_eu + 6, 2) as price
, round(amazon_eu_minimum_price + 6, 2) as [minimum-seller-allowed-price]
, round(amazon_list_price_eu + 6 ,2) as [maximum-seller-allowed-price]
, 1 as quantity
, 5 as [handling-time]
, ‘default’ as [fulfillment-channel]
remove-this-phrase–, s.[Stock status]
from [new_price_calculations_feb-24-2019] p
inner join SpainAllListingsReport02272019 sp on trim(sp.[seller_sku])=trim(p.sku)
remove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
remove-this-phrase–inner join [supplier-jan-10-2019] s on trim(concat(‘shopforsoul-‘,s.[Model Code]))=trim(p.sku)
where (sp.status=’Active’) and (p.status=1)
remove-this-phrase–and s.[Stock status] = ‘In Stock’
remove-this-phrase–and sku like ‘%shopforsoul-PTO_03FTX3%’
remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–remove-this-phrase–
remove-this-phrase–deactivate on amazon as they are disabled on ShopForSoul.com
select p.sku
, round(amazon_special_price_usd,2) as price
, round(amazon_usd_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price_usd,2) as [maximum-seller-allowed-price]
, 0 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel]
, uk.asin1 as asinremove-this-phrase–, ‘Inactive’ as status
from july_22nd_2019__price_calculations p
remove-this-phrase–inner join UkAllListingsReport08262019 usa on trim(usa.[seller-sku])=trim(p.sku)
inner join UkAllListingsReport08262019 uk on trim(uk.[seller-sku])=trim(p.sku)
remove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
where (uk.status=’Active’) and (p.status=1)
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
