USE [AdjustInActiveInventory] GO /****** Object: StoredProcedure [dbo].[update_inactive_listings_uk] Script Date: 2020-06-19 9:55:55 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].[update_inactive_listings_uk] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with …
Category: manage-selling-on-amazon-using-sql
Jun 19
android_product_name_mismatch
USE ProductAndPriceManagement GO /****** Object: StoredProcedure [dbo].[android_product_name_mismatch] Script Date: 2020-06-19 9:53:31 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].[android_product_name_mismatch] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with …
Jun 19
product_name_mismatch
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: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[product_name_mismatch] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with …
Jun 19
minimum_price_for_amazon
USE ProductAndPriceManagement GO /****** Object: StoredProcedure [dbo].[minimum_price_for_amazon] Script Date: 2020-06-19 9:57:08 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].[minimum_price_for_amazon] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with …
Jun 19
xls_auto_pricing_data_for_usa
/****** 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: <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_usa] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with SELECT statements. SET …
Jun 19
xls_auto_pricing_data_for_Uk_eu
/****** 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 …
Jun 19
xls_auto_pricing_data_for_canada
/****** 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: <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_canada] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with SELECT statements. SET …
Jun 19
why_status_inactive
/****** Object: StoredProcedure [dbo].[why_status_inactive] 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].[why_status_inactive] AS BEGIN select p.[Stock Status], s.[Stock Status] ,trim(concat(‘shopforsoul-‘,s.[Model Code])) ,trim(p.sku) , p.* from [price_calculations_feb-01-2019] p remove-this-phrase–inner join CanadaAllListingsReport02042019 canada …
Jun 19
update_supplier_sku
/****** Object: StoredProcedure [dbo].[update_supplier_sku] 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].[update_supplier_sku] AS BEGIN update [DealWithAmazonShopForSoul].[dbo].[supplier-dec-28-2018] set Model_Code=concat(‘shopforsoul-‘, Model_Code) where Model_Code not like ‘%shopfor%’; END GO *** . *** *** . …
Jun 19
update_sku_once_for_price_calculations
USE [AmazonShopForSoul] GO /****** Object: StoredProcedure [dbo].[update_sku_once_for_price_calculations] 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: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[update_sku_once_for_price_calculations] AS BEGIN select * from price_calculations where sku not like ‘%shopfor%’; update price_calculations set sku=concat(‘shopforsoul-‘, sku) …
