http://forums.aspdotnetstorefront.com/ en Fri, 24 May 2013 13:18:48 GMT vBulletin 60 http://forums.aspdotnetstorefront.com/images/misc/rss.png http://forums.aspdotnetstorefront.com/ http://forums.aspdotnetstorefront.com/showthread.php?141603-Updating-Quantities-direct-from-local-database-to-aspdotnet-db&goto=newpost Thu, 02 May 2013 12:27:25 GMT I am looking to automate updating my quantities on the shopping cart without having to do an import from excel. I would like to create a local query that pulls the quantities out of my back-end database and updates the quantities on the shopping cart database. I can do it when both db reside on... I am looking to automate updating my quantities on the shopping cart without having to do an import from excel. I would like to create a local query that pulls the quantities out of my back-end database and updates the quantities on the shopping cart database. I can do it when both db reside on my server (which i did for my local test site) but when I tried to run it on the production site, it did error out. Does anyone have experience with this? Below is a test query I did locally.


UPDATE [dbo].[ProductVariant]
set Inventory = [companyDB].[DBO].ITMFIL.ITEM_RT_QTY_ON_HND
from [dbo].[ProductVariant] AS V inner join [DBO].Product AS P ON V.ProductID = P.ProductID
INNER JOIN [companyDB].[dbo].ITMFIL on P.SKU = ITEM_NO
where P.SKU = 'PART-1234'

I did this in the management studio while connected to the live db. I did put the local computer name but got an error message stating that the computer name was not in sys.systems.

Any help would be great.

Thanks ]]> Database rcc866 http://forums.aspdotnetstorefront.com/showthread.php?141603-Updating-Quantities-direct-from-local-database-to-aspdotnet-db http://forums.aspdotnetstorefront.com/showthread.php?141475-SQL-Query-String&goto=newpost Mon, 29 Apr 2013 14:15:10 GMT I have a temp table on my DB called CSV_Import that I import XLS files into, this table has 2 rows, SKU and EAN. I am trying to build a query needs to reference the SKU from the CSV_Import table, then find the SKU in either the Product or ProductVariant table and update the DownloadLocation row... I have a temp table on my DB called CSV_Import that I import XLS files into, this table has 2 rows, SKU and EAN.

I am trying to build a query needs to reference the SKU from the CSV_Import table, then find the SKU in either the Product or ProductVariant table and update the DownloadLocation row in ProductVariant (where we place our EAN's).

I am struggling when a product has many variants and many different SKU's as none of the fields in the SKU row on the table Product have an entry. What happens then is that the SKUSuffix row on the ProductVariant table will have the entry that needs to be queried.

This the SQL Query that I have at the moment....

UPDATE ProductVariant
SET DownloadLocation = CSV_Import.ean
FROM ProductVariant AS ProductVariant
INNER JOIN Product AS Product ON ProductVariant.ProductID=Product.ProductID
INNER JOIN CSV_Import ON Product.SKU = CSV_Import.SKU

Can anyone offer some help? ]]> Database DotNetDevelopments http://forums.aspdotnetstorefront.com/showthread.php?141475-SQL-Query-String