USE [AmazonShopForSoul] GO /****** Object: StoredProcedure [dbo].[update_sku_once] 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] AS BEGIN select * from all_to_upload_without_description where sku not like ‘%shopfor%’; update price_calculations_jul_17_2018 set sku=concat(‘shopforsoul-‘, sku) …
Category: manage-selling-on-amazon-using-sql
Jun 19
update_inactive_listings_uk
USE [AdjustInActiveInventory] GO /****** Object: StoredProcedure [dbo].[update_inactive_listings_uk] Script Date: 2020-06-19 10:18:38 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 …
Jun 19
update_inactive_listings_eu
USE [AdjustInActiveInventory] GO /****** Object: StoredProcedure [dbo].[update_inactive_listings_eu] Script Date: 2020-06-19 10:18:38 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_eu] as BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with …
Jun 19
update_exchange_rate_and_price
USE [AmazonProfitLossOrderManagement] GO /****** Object: StoredProcedure [dbo].[update_exchange_rate_and_price] Script Date: 2020-06-19 10:17:11 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– Alter Procedure update_exchange_rate_and_price 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_exchange_rate_and_price] @exchange_rate_from_eu float, @exchange_rate_from_gbp float AS BEGIN remove-this-phrase– SET NOCOUNT ON added to …
Jun 19
test
USE [AmazonProfitLossOrderManagement] GO /****** Object: StoredProcedure [dbo].[test] Script Date: 2020-06-19 10:17:11 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].[test] AS BEGIN /****** Script for SelectTopNRows command from SSMS ******/ SELECT ama.*remove-this-phrase–, c.* FROM [AmazonProfitLossOrderManagement].[dbo].[order_and_profit_loss_mgmt_july_15th_2018] ama …
Jun 19
sync_with_uk_inventory
/****** 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: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <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– interfering with SELECT statements. SET …
Jun 19
product_name_mismatch
USE [AmazonInventory-2018-06-14] GO /****** Object: StoredProcedure [dbo].[product_name_mismatch] Script Date: 2020-06-19 10:18:12 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
our_profit_loss
USE [AmazonProfitLossOrderManagement] GO /****** Object: StoredProcedure [dbo].[our_profit_loss] Script Date: 2020-06-19 10:17:11 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– Alter Procedure our_profit_loss 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].[our_profit_loss] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets …
Jun 19
minimum_price_for_amazon
USE [AmazonMinimumPriceAdjustment] GO /****** Object: StoredProcedure [dbo].[minimum_price_for_amazon] Script Date: 2020-06-19 10:17:46 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
generate_price_calculation_data
/****** 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] …
