{"id":17188,"date":"2020-06-19T23:00:03","date_gmt":"2020-06-20T03:00:03","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/xls_auto_pricing_data_for_uk_eu-2\/"},"modified":"2020-06-20T13:25:02","modified_gmt":"2020-06-20T17:25:02","slug":"xls_auto_pricing_data_for_uk_eu-2","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=17188","title":{"rendered":"xls_auto_pricing_data_for_Uk_eu"},"content":{"rendered":"

\/****** Object: StoredProcedure [dbo].[xls_auto_pricing_data_for_Uk_eu] Script Date: 2020-06-19 10:15:42 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].[xls_auto_pricing_data_for_Uk_eu]
\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

update july_22nd_2019__price_calculations
\nset sku=concat(‘shopforsoul-‘, sku)
\nwhere sku not like ‘%shopfor%’;<\/p>\n

remove-this-phrase–select * from CanadaAllListingsReport12252018;
\nremove-this-phrase–minimum price update
\nselect trim(uk.[seller-sku]) as sku
\nremove-this-phrase–select trim(canada.[seller_sku]) as sku
\nremove-this-phrase–,p.sku
\nremove-this-phrase–,trim(concat(‘shopforsoul-‘,s.[Model Code]))
\n, round(amazon_special_price_gbp + 6, 2) as price
\n, round(amazon_gbp_minimum_price + 6, 2) as [minimum-seller-allowed-price]
\n, round(amazon_list_price_gbp + 6 ,2) as [maximum-seller-allowed-price]
\n, 1 as quantity
\n, 10 as [handling-time]
\n, ‘default’ as [fulfillment-channel]
\nremove-this-phrase–, s.[Stock status]<\/p>\n

from july_22nd_2019__price_calculations p
\ninner join UkAllListingsReport08262019 uk on trim(uk.[seller-sku])=trim(p.sku)
\nremove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
\nremove-this-phrase–inner join [supplier-jan-10-2019] s on trim(concat(‘shopforsoul-‘,s.[Model Code]))=trim(p.sku)
\nwhere (uk.status=’Active’) and (p.status=1)
\nremove-this-phrase–and s.[Stock status] = ‘In Stock’
\nremove-this-phrase–and sku like ‘%shopforsoul-PTO_03FTX3%’<\/p>\n

remove-this-phrase–#FranceAllListingsReport02272019
\nremove-this-phrase–minimum price update
\nselect fr.[seller-sku] as sku
\nremove-this-phrase–select trim(canada.[seller_sku]) as sku
\nremove-this-phrase–,p.sku
\nremove-this-phrase–,trim(concat(‘shopforsoul-‘,s.[Model Code]))
\n, round(amazon_special_price_eu + 6, 2) as price
\n, round(amazon_eu_minimum_price + 6, 2) as [minimum-seller-allowed-price]
\n, round(amazon_list_price_eu + 6 ,2) as [maximum-seller-allowed-price]
\n, 1 as quantity
\n, 10 as [handling-time]
\n, ‘default’ as [fulfillment-channel]
\nremove-this-phrase–, s.[Stock status]<\/p>\n

from july_22nd_2019__price_calculations p
\ninner join SpainAllListingsReport08262019 fr on fr.[seller-sku]=trim(p.sku)
\nremove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
\nremove-this-phrase–inner join [supplier-jan-10-2019] s on trim(concat(‘shopforsoul-‘,s.[Model Code]))=trim(p.sku)
\nwhere (fr.status=’Active’) and (p.status=1) and (fr.[seller-sku] like ‘%shopforsoul%’)
\nremove-this-phrase–and s.[Stock status] = ‘In Stock’
\nremove-this-phrase–and sku like ‘%shopforsoul-PTO_03FTX3%’<\/p>\n

remove-this-phrase—
\nremove-this-phrase–#spain
\nremove-this-phrase–minimum price update
\nselect trim(sp.[seller_sku]) as sku
\nremove-this-phrase–select trim(canada.[seller_sku]) as sku
\nremove-this-phrase–,p.sku
\nremove-this-phrase–,trim(concat(‘shopforsoul-‘,s.[Model Code]))
\n, round(amazon_special_price_eu + 6, 2) as price
\n, round(amazon_eu_minimum_price + 6, 2) as [minimum-seller-allowed-price]
\n, round(amazon_list_price_eu + 6 ,2) as [maximum-seller-allowed-price]
\n, 1 as quantity
\n, 5 as [handling-time]
\n, ‘default’ as [fulfillment-channel]
\nremove-this-phrase–, s.[Stock status]<\/p>\n

from [new_price_calculations_feb-24-2019] p
\ninner join SpainAllListingsReport02272019 sp on trim(sp.[seller_sku])=trim(p.sku)
\nremove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
\nremove-this-phrase–inner join [supplier-jan-10-2019] s on trim(concat(‘shopforsoul-‘,s.[Model Code]))=trim(p.sku)
\nwhere (sp.status=’Active’) and (p.status=1)
\nremove-this-phrase–and s.[Stock status] = ‘In Stock’
\nremove-this-phrase–and sku like ‘%shopforsoul-PTO_03FTX3%’<\/p>\n

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–
\nremove-this-phrase–deactivate on amazon as they are disabled on ShopForSoul.com
\nselect p.sku
\n, round(amazon_special_price_usd,2) as price
\n, round(amazon_usd_minimum_price,2) as [minimum-seller-allowed-price]
\n, round(amazon_list_price_usd,2) as [maximum-seller-allowed-price]
\n, 0 as quantity, 4 as [handling-time]
\n, ‘default’ as [fulfillment-channel]
\n, uk.asin1 as asinremove-this-phrase–, ‘Inactive’ as status
\nfrom july_22nd_2019__price_calculations p
\nremove-this-phrase–inner join UkAllListingsReport08262019 usa on trim(usa.[seller-sku])=trim(p.sku)
\ninner join UkAllListingsReport08262019 uk on trim(uk.[seller-sku])=trim(p.sku)
\nremove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
\nwhere (uk.status=’Active’) and (p.status=1)<\/p>\n

END
\nGO
\n*** . *** *** . *** . *** . ***<\/p>\n

Training Courses: <\/strong>http:\/\/Training.SitesTree.com<\/a> <\/em>
\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

<\/em>
\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

Facebook Groups\/Forums to discuss (Q & A): <\/strong><\/em>
\nhttps:\/\/www.facebook.com\/salearningschool<\/a><\/p>\n

https:\/\/www.facebook.com\/banglasalearningschool<\/a>
\nhttps:\/\/www.facebook.com\/justetcsocial<\/a><\/p>\n

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>
\nFinance: https:\/\/www.facebook.com\/groups\/1792339521056034<\/a><\/p>\n

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

JustEtc: https:\/\/www.facebook.com\/JustETC-Technologies-Inc-289864738261<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\/****** 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 … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1915,182],"tags":[],"class_list":["post-17188","post","type-post","status-publish","format-standard","hentry","category-selling-on-amazon","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":17178,"url":"http:\/\/bangla.sitestree.com\/?p=17178","url_meta":{"origin":17188,"position":0},"title":"sync_with_uk_inventory","author":"Sayed","date":"June 19, 2020","format":false,"excerpt":"\/****** Object: StoredProcedure [dbo].[sync_with_uk_inventory] Script Date: 2020-06-19 10:12:46 PM ******\/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase-- ============================================= remove-this-phrase-- Author: remove-this-phrase-- Create date: remove-this-phrase-- Description: remove-this-phrase-- ============================================= CREATE PROCEDURE [dbo].[sync_with_uk_inventory] AS BEGIN remove-this-phrase-- SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase--\u2026","rel":"","context":"In "manage-selling-on-amazon-using-sql"","block_context":{"text":"manage-selling-on-amazon-using-sql","link":"http:\/\/bangla.sitestree.com\/?cat=1915"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17187,"url":"http:\/\/bangla.sitestree.com\/?p=17187","url_meta":{"origin":17188,"position":1},"title":"xls_auto_pricing_data_for_canada","author":"Sayed","date":"June 19, 2020","format":false,"excerpt":"\/****** Object: StoredProcedure [dbo].[xls_auto_pricing_data_for_canada] 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: remove-this-phrase-- Create date: remove-this-phrase-- Description: remove-this-phrase-- ============================================= CREATE PROCEDURE [dbo].[xls_auto_pricing_data_for_canada] AS BEGIN remove-this-phrase-- SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase--\u2026","rel":"","context":"In "manage-selling-on-amazon-using-sql"","block_context":{"text":"manage-selling-on-amazon-using-sql","link":"http:\/\/bangla.sitestree.com\/?cat=1915"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17189,"url":"http:\/\/bangla.sitestree.com\/?p=17189","url_meta":{"origin":17188,"position":2},"title":"xls_auto_pricing_data_for_usa","author":"Sayed","date":"June 19, 2020","format":false,"excerpt":"\/****** Object: StoredProcedure [dbo].[xls_auto_pricing_data_for_usa] 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: remove-this-phrase-- Create date: remove-this-phrase-- Description: remove-this-phrase-- ============================================= CREATE PROCEDURE [dbo].[xls_auto_pricing_data_for_usa] AS BEGIN remove-this-phrase-- SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase--\u2026","rel":"","context":"In "manage-selling-on-amazon-using-sql"","block_context":{"text":"manage-selling-on-amazon-using-sql","link":"http:\/\/bangla.sitestree.com\/?cat=1915"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17164,"url":"http:\/\/bangla.sitestree.com\/?p=17164","url_meta":{"origin":17188,"position":3},"title":"adjust_stock_status_data_for_canada","author":"Sayed","date":"June 19, 2020","format":false,"excerpt":"\/****** Object: StoredProcedure [dbo].[adjust_stock_status_data_for_canada] 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: remove-this-phrase-- Create date: remove-this-phrase-- Description: remove-this-phrase-- ============================================= CREATE PROCEDURE [dbo].[adjust_stock_status_data_for_canada] AS BEGIN remove-this-phrase-- SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase--\u2026","rel":"","context":"In "Finance"","block_context":{"text":"Finance","link":"http:\/\/bangla.sitestree.com\/?cat=50"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17163,"url":"http:\/\/bangla.sitestree.com\/?p=17163","url_meta":{"origin":17188,"position":4},"title":"remove this word product_name_mismatch","author":"Sayed","date":"June 19, 2020","format":false,"excerpt":"USE ProductAndPriceManagement GO \/****** Object: StoredProcedure [dbo].[product_name_mismatch] Script Date: 2020-06-19 9:56:07 PM ******\/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase-- ============================================= remove-this-phrase-- Author: remove-this-phrase-- Create date: remove-this-phrase-- Description: remove-this-phrase-- ============================================= CREATE PROCEDURE [dbo].[product_name_mismatch] AS BEGIN remove-this-phrase-- SET NOCOUNT ON added to prevent extra result\u2026","rel":"","context":"In "manage-selling-on-amazon-using-sql"","block_context":{"text":"manage-selling-on-amazon-using-sql","link":"http:\/\/bangla.sitestree.com\/?cat=1915"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17166,"url":"http:\/\/bangla.sitestree.com\/?p=17166","url_meta":{"origin":17188,"position":5},"title":"auto_pricing_data_for_canada","author":"Sayed","date":"June 19, 2020","format":false,"excerpt":"USE [AmazonShopForSoul] GO \/****** Object: StoredProcedure [dbo].[auto_pricing_data_for_canada] Script Date: 2020-06-19 10:16:30 PM ******\/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase-- ============================================= remove-this-phrase-- Author: remove-this-phrase-- Create date: remove-this-phrase-- Description: remove-this-phrase-- ============================================= CREATE PROCEDURE [dbo].[auto_pricing_data_for_canada] AS BEGIN remove-this-phrase-- SET NOCOUNT ON added to prevent extra result\u2026","rel":"","context":"In "manage-selling-on-amazon-using-sql"","block_context":{"text":"manage-selling-on-amazon-using-sql","link":"http:\/\/bangla.sitestree.com\/?cat=1915"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/17188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17188"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/17188\/revisions"}],"predecessor-version":[{"id":17229,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/17188\/revisions\/17229"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17188"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}