Inicijalni import cenovnika se sastoji iz dva obavezna koraka, kao i trećeg opcionalnog (ako se cene koriste iz skladišta).
Da bi import cenovnika bio uspešan, potrebno je proveriti da li su sledeće stavke importovane i up to date:
Predmet: Cenovnici
Forme: Main, Process Template Gallery
Procedure: _el_pantheon_pricing_import
Tabele: productpricing
Prvi korak je da se dropuju postojeće tabele i kreiraju View-evi tih istih tabela. Tabele nad kojima se vrši manipulacija su:
tHE_SetSubjPriceItem,
tHE_SetSubjPriceCateg,
tHE_SetSubjTypePriceItem,
tHE_SetSubjTypePriceCateg.
drop table tHE_SetSubjPriceItem --1. korak
alter view tHE_SetSubjPriceItem --2. korak
as
(select [subject] AS acSubject,
proizvod AS acIdent,
typeof AS acInvoInOut,
datefrom AS adDateStart,
dateto AS adDateEnd,
acType AS acType,
price AS anPrice,
[percentage] AS anRebate,
acSetOf AS acSetOf,
valuta AS acCurrency,
acFormula,
anDeliveryDeadline AS anDeliveryDeadline,
anPaymentDeadline AS anPaymentDeadline,
anUserIns AS anUserIns,
adTimeIns AS adTimeIns,
anUserChg AS anUserChg,
adTimeChg AS adTimeChg,
anSalePrice as anSalePrice,
anRebate2 as anRebate2,
anRebate3 AS anRebate3,
acDocKey as acDocKey,
imported,
sort
from productpricing
where acType = "P")
-------------------------------------------------------------------------------------------------------------------
drop table tHE_SetSubjPriceCateg --3. korak
alter view tHE_SetSubjPriceCateg --4. korak
as
(select [subject] AS acSubject,
classif AS acClassif,
typeof AS acInvoInOut,
datefrom AS adDateStart,
dateto AS adDateEnd,
acType AS acType,
price AS anPrice,
[percentage] AS anRebate,
acSetOf AS acSetOf,
valuta AS acCurrency,
acFormula,
anDeliveryDeadline AS anDeliveryDeadline,
anPaymentDeadline AS anPaymentDeadline,
anUserIns AS anUserIns,
adTimeIns AS adTimeIns,
anUserChg AS anUserChg,
adTimeChg AS adTimeChg,
anSalePrice as anSalePrice,
anRebate2 as anRebate2,
anRebate3 AS anRebate3,
imported,
sort
from productpricing
where acType = "K")
-------------------------------------------------------------------------------------------------------------------
drop table tHE_SetSubjTypePriceItem --5. korak
alter view tHE_SetSubjTypePriceItem --6. korak
as
(select typeof_subject AS acSubjType,
proizvod AS acIdent,
typeof AS acInvoInOut,
datefrom AS adDateStart,
dateto AS adDateEnd,
acType AS acType,
price AS anPrice,
[percentage] AS anRebate,
acSetOf AS acSetOf,
valuta AS acCurrency,
acFormula,
anDeliveryDeadline AS anDeliveryDeadline,
anPaymentDeadline AS anPaymentDeadline,
anUserIns AS anUserIns,
adTimeIns AS adTimeIns,
anUserChg AS anUserChg,
adTimeChg AS adTimeChg,
anSalePrice as anSalePrice,
anRebate2 as anRebate2,
anRebate3 AS anRebate3,
imported,
sort
from productpricing
where acType = "M")
-------------------------------------------------------------------------------------------------------------------
drop table tHE_SetSubjTypePriceCateg --7. korak
alter view tHE_SetSubjTypePriceCateg --8. korak
as
(select typeof_subject AS acSubjType,
classif AS acClassif,
typeof AS acInvoInOut,
datefrom AS adDateStart,
dateto AS adDateEnd,
acType AS acType,
price AS anPrice,
[percentage] AS anRebate,
acSetOf AS acSetOf,
valuta AS acCurrency,
acFormula,
anDeliveryDeadline AS anDeliveryDeadline,
anPaymentDeadline AS anPaymentDeadline,
anUserIns AS anUserIns,
adTimeIns AS adTimeIns,
anUserChg AS anUserChg,
adTimeChg AS adTimeChg,
anSalePrice as anSalePrice,
anRebate2 as anRebate2,
anRebate3 AS anRebate3,
imported,
sort
from productpricing
where acType = "T")
-------------------------------------------------------------------------------------------------------------------Nakon što su tabele prebačene u view, treba izvšiti import cenovnika sa klijentske baze.
Import je moguće odraditi na 2 načina:
U aplikaciji u "Setup" meniju se nalazi deo ERP Imp / Exp gde se nalazi lista sa dostupnim sinhronizacijama. Klikom na dugme Import kod opcije Cenovnik će se pokrenuti proces importa cenovnika.
Ručni import se može izvršiti pozivom procedure _el_pantheon_pricing_import sa sledećim parametrima:
"- server: klijentski server
- database: klijentska baza
- method: metoda importa
exec _el_pantheon_pricing_import "server", "database", "method"U slučaju kada se koristi određeno skladište kao cenovnik za online katalog, potrebno je cene iz tog skladišta updateovati u MS.
Primer koda:
declare @acident nvarchar(20), @anRTPrice float, @anSalePrice float, @acckey nvarchar(20)
declare updms cursor for
select s.acident,s.anRTPrice, s.anSalePrice--, i.anRTPrice,i.anSalePrice
from tHE_SetItemPriceForWrh s
left join tHE_SetItem i on s.acIdent = i.acIdent
where acwarehouse = "Online prodaja"
and i.acActive = "T"
and i.acShowAtena = "T"
open updms
fetch next from updms into @acident, @anRTPrice, @anSalePrice
while @@FETCH_STATUS = 0
begin
print @acident
update tHE_SetItem
set anRTPrice = @anRTPrice,
anSalePrice = @anSalePrice
where acIdent = @acident
set @acckey = (select acckey from _service where oddelek = "21S01002971" and ident = @acident)
print @acckey
if ISNULL(@acckey,"") <> ""
begin
exec _el_updatecustomfield @acckey, "21S01002971", "fieldn6", @anRTPrice
exec _el_updatecustomfield @acckey, "21S01002971", "fieldn13", @anSalePrice
--exec _el_updateembeddhtml_case @acckey,"21S01002971"
end
print "------------------------------------------------"
fetch next from updms into @acident, @anRTPrice, @anSalePrice
end
close updms
deallocate updms