Jun 22

Target Tracking: Closely Separated Targets. Algorithms and Performance

What are the two types of tracking measures?

  • Measures of performance (MOP)
  • measures of effectiveness (MOE)

What are the two broad categories for MOP and MOE?

  • Sensor-related
    • sensor characteristics
  • Tracker-related
    • algorithm-free and algorithm-dependent

Give some information on Algorithm and Algorithm Free

  • Algorithm Dependent
    • Track scores in the Multiple Hypothesis tracker
  • Algorithm Free
    • Applicable to any tracker

What are different types of Tracker

  • Single-hypothesis tracker
  • Multiple-hypothesis tracker
  • Probabilistic data association tracker

What is a great way to track maneuvering targets better?

  • Estimate the motion of the targets by using various models

What are some objectives of target tracking? What are some of the concerns that tracking wants to answer?

“

  • How many objects are there?
  • Where are the objects located in space?
  • What is their speed and direction of motion?
  • How do the objects maneuver relative to each other?

“

What is one challenge in detecting/tracking closely separated targets?

  • If the targets are in one sensor resolution cell, then only one target will be reported

What is the simplest choice for multi-target tracking?

  • Single-hypothesis tracker like the GNN

How does interacting multiple-model (IMM) help in tracking?

  • IMM can help to find the correct motion models of the targets

What can help with broken tracks?

  • a multiple-hypothesis tracker (MHT)

How does MHT help with this?

  • It can create and maintain multiple tracks for ambiguous situations and
  • then resolves for ambiguity for better tracking
  • MHT can improve the tracking when the targets turn (and go away from one another)

Compare JPDA and MHT

  • MHT can be slower than JPDA
  • JPDA can be thought of sub-optimal tracking where MHT is more optimal tracking
  • MHT is usually slower

How does JPDA work and how is this different from MHT?

  • “JPDA allows a single detection to be used for updating multiple tracks in its vicinity. Moreover, multiple detections can be clustered together with several tracks and update each of those tracks. This resolves the issue of the broken track.”

How is track status kept in JPDA for ambiguous regions?

  • Confirmed

Can IMM be used with JPDA?

  • Yes

How does IMM with JPDA help?

  • Provides better before turn tracking
  • the turn before the ambiguity region is better addressed

Are GNN and JPDA faster than MHT?

  • Yes

Give an example when the Constant Velocity model does not give better tracking?

  • Maneuvering targets
  • How can that be improved
    • Use IMM

The algorithms as discussed which one is the best overall and in general

  • JPDA

Still JPDA is faster and great, can there be a scenario where JPDA is not appropriate?

  • Too much ambiguity where JPDA or GNN cannot give proper tracking

References: The fusion example TrackingCloselySpacedTargetsUnderAmbiguityExample in Matlab document

*** . *** *** . *** . *** . ***

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

Jun 20

Why-early-retirement-is-a-wrong-goal.aspx

Why-early-retirement-is-a-wrong-goal.aspx

https://www.morningstar.ca/ca/news/203331/why-early-retirement-is-a-wrong-goal.aspx

https://www.morningstar.ca/ca/news/191643/canadians-arent-ready-to-retire.aspx

https://www.youtube.com/watch?reload=9&v=KR_eIoIo2vU

https://www.morningstar.ca/ca/news/201514/getting-retirement-ready-in-turbulent-times.aspx

https://www.morningstar.ca/ca/news/195746/four-retirement-planning-blind-spots.aspx

*** . *** *** . *** . *** . ***

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

Jun 19

update_inactive_listings_uk

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 SELECT statements.
SET NOCOUNT ON;

select p.sku, uk.asin1 as [product-id], uk.[product-id-type]
,p.amazon_special_price_gbp as price, p.amazon_gbp_minimum_price as [minimum-seller-allowed-price], p.amazon_list_price_gbp as [maximum-seller-allowed-price]
, uk.[item-condition], 2 as quantity, ‘a’ as [add-delete], 2 as [handling-time]
remove-this-phrase–, ‘default’ as [fulfillment-channel]
remove-this-phrase–,p.status, uk., uk.*
from UkAllListingsReport07092018 uk
inner join AllProductsPriceCalculation p on trim(p.sku) = trim(uk.[seller-sku])
where (uk. = ‘Inactive’) and (p.status = 1) and (uk.[item-name] not like ‘%tv%’ )
order by uk. desc

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

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 SELECT statements.
SET NOCOUNT ON;

SELECT ama.asin1, ama.[seller-sku], supplier.sku, ama.[item-name] as name_on_amazon, supplier.name as name_at_supplier_side
FROM [ActiveListingsReport-06-19-2018] ama
inner join [all-to-upload-without-description] supplier on trim(ama.[seller-sku])=concat(‘shopforsoul-‘,supplier.sku)
where ama.[item-name] <> supplier.name and ( (ama.[item-name] like ‘%android%’) or (supplier.name like ‘%android%’) )
order by ama.[item-name]

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

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 SELECT statements.
SET NOCOUNT ON;

/****** Script for SelectTopNRows command from SSMS ******/
SELECT ama.asin1, ama.[seller-sku], supplier.sku, ama.[item-name] as name_on_amazon, supplier.name as name_at_supplier_side
FROM [ActiveListingsReport-06-19-2018] ama
inner join [all-to-upload-without-description] supplier on trim(ama.[seller-sku])=concat(‘shopforsoul-‘,supplier.sku)
where ama.[item-name] <> supplier.name
order by ama.[item-name]

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

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 SELECT statements.
SET NOCOUNT ON;

SELECT ours.*
FROM [our_canadian_prices_for_minimum-maximum_template] ours
inner join [canada-Inventory+Report+07-02-2018] canada on canada.sku = ours.sku

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

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 NOCOUNT ON;

update price_calculations_dec_23_2018
set sku=concat(‘shopforsoul-‘, sku)
where sku not like ‘%shopfor%’;

remove-this-phrase–select * from CanadaAllListingsReport12252018;

remove-this-phrase–minimum price update
select trim(usa.[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_usd + 6, 2) as price
, round(amazon_usd_minimum_price + 6, 2) as [minimum-seller-allowed-price]
, round(amazon_list_price_usd + 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_04_2019] p
inner join UsaListFeb162019 usa on trim(usa.[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 (usa.status=’Active’) and (p.status=1)
remove-this-phrase–and s.[Stock status] = ‘In Stock’

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]
, usa.asin1 as asinremove-this-phrase–, ‘Inactive’ as status
from [new_price_calculations_feb_04_2019] p
inner join UsaListFeb162019 usa on trim(usa.[seller-sku])=trim(p.sku)
remove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
where (usa.status=’Active’) and (p.status=2)

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

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 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

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 NOCOUNT ON;

update price_calculations_dec_23_2018
set sku=concat(‘shopforsoul-‘, sku)
where sku not like ‘%shopfor%’;

remove-this-phrase–select * from CanadaAllListingsReport12252018;

remove-this-phrase–minimum price update
select trim(canada.[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 + 6, 2) as price
, round(amazon_ca_minimum_price + 6, 2) as [minimum-seller-allowed-price]
, round(amazon_list_price + 6 ,2) as [maximum-seller-allowed-price]
, 1 as quantity
, 7 as [handling-time]
, ‘default’ as [fulfillment-channel]
remove-this-phrase–, s.[Stock status]

from [new_price_calculations_feb_04_2019] p
inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[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 (canada.status=’Active’) and (p.status=1)
remove-this-phrase–and s.[Stock status] = ‘In Stock’

remove-this-phrase–deactivate on amazon as they are disabled on ShopForSoul.com
select p.sku
, round(amazon_special_price,2) as price
, round(amazon_ca_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price,2) as [maximum-seller-allowed-price]
, 0 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel]
, canada.asin1 as asinremove-this-phrase–, ‘Inactive’ as status
from [new_price_calculations_feb_04_2019] p
inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller-sku])=trim(p.sku)
remove-this-phrase–inner join NewCanadaAllListingsReport02062019 canada on trim(canada.[seller_sku])=trim(p.sku)
where (canada.status=’Active’) and (p.status=2)

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

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 on trim(canada.[seller-sku])=trim(p.sku)
inner join [supplier_feb_01_2019] s on trim(concat(‘shopforsoul-‘,s.[Model Code]))=trim(p.sku)
remove-this-phrase–where (canada.status=’Active’) and (p.status=1)
and s.[Stock status] = ‘In Stock’
and p.status=2
and p.raw_price > 30
and p.cheapest_courier_shipping < 500
and p.product_ean <> ”
and p.[Name] not like ‘%tv%box%’

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