Export to Stock take

[The Drum]

Hi, I am trying to find a way to export my data in order to 'stock take', as opposed to stock taking each individual product separately within the Sellerdeck Desktop program.
Although my products will have different stock levels I feel it would be easier to undertake this on a spreadsheet just by tabbing down to each one and entering a value.
The only option i see is using the File/Export to excel in either tab or comma delimited format, however this brings up a totally unreadable spreadsheet and impossible to navigate.
All I need is to do this once, then re-import to the SD program, the sales will then automatically adjust the levels from thereon in.
I have seen a program that will do this for me, but this operation is a 'one off' and such expense is unwelcome at the moment for something that is likely to not be used again.
I guess I am surprised that there is nothing within the SD software that allows this to be undertaken with more ease.
Thank you.

[EdHarrison]

Talk to Andy at codepath

[The Drum]

Talk to Andy at codepath

Hi Ed, Yes I was looking at that, and I know his program is well packed with facilities. I guess I was hoping that I had missed something in SD that would do that simple task for me. As I subscribe with a tidy cost to the support package and rarely call upon it, so was hoping for a solution without further costings i guess. Thanks, I appreciate the suggestion.

[EdHarrison]

Same here, I find myself paying for add ons and support from a developer despite having a 365 contract sadly. I really like sellerdeck (must do been using it since 2098 lol) but there are frustrations.

[rookers]

Did you know you can click Operations, Stock Levels - there is a sortable table there that you could use to update the figures.

[NormanRouxel]

You can use SellerDeck's list functionality to generate a custom report with only a few steps.
Go to Design / Library / Layouts / Fragments.
Right click "Text Left Of Image" and choose Copy.
Rename that copy to be "Stock Display".
Open "Stock Display" and replace all contents with:

Ref,Name,IsStockMonitored,Stocklevel,RawPrice
<actinic:block type="EntireSectionList"><actinic:block type="SectionEntireProductList"><actinic:block if="%3cactinic%3avariable%20name%3d%22ProductType%22%20%2f%3e%20%3d%3d%200" >
<br>"<actinic:variable name="ProductReference" encoding="perl" />","<actinic:block php="true">echo str_replace('"', '""', '<actinic:variable encoding="perl" selectable="false" name="ProductName" />');</actinic:block>",<actinic:variable name="IsStockMonitored" />,<actinic:variable name="StockLevel" />,<actinic:variable name="ProductPriceRaw" />
</actinic:block></actinic:block></actinic:block>

OK out, set a Fragment to use "Stock Display" as its layout, Preview it and copy / paste the displayed data to a file to use in a spreadsheet.

You'll get a list like:

Ref,Name,IsStockMonitored,Stocklevel,RawPrice
"47","Engagement Ring",0,0,240
"1","Three Diamond Ring",0,-10,20
"2","Wedding Rings",1,100,130
"3","Solitaire Diamond Ring",0,0,150
"23","Diamond Pendant",0,25,80
"24","Gold Chain",0,25,80
"123-45","Amethyst Heart Necklace",1,2,50
"26","Pearl Necklace",1,23,60
"20","Picture Frame Locket",0,25,25
"21","Golden Heart Locket",0,25,30
"22","Pearl Locket",0,25,35
"27","Men's Engraved 3"" Bracelet",1,25,30
"28","Multi Pearl Bracelet",0,-6,80

Edit the bit of code to add in other Variables if needed. Help / Variable Reference Guide will show what's available.

[The Drum]

Did you know you can click Operations, Stock Levels - there is a sortable table there that you could use to update the figures.

I did not know that, incredibly none of the SD support mentioned it either:/.... Just had a look and I think that could do the job, certainly quicker than editing each individual product in the product window. Thank you

[The Drum]

You can use SellerDeck's list functionality to generate a custom report with only a few steps.
Go to Design / Library / Layouts / Fragments.
Right click "Text Left Of Image" and choose Copy.
Rename that copy to be "Stock Display".
Open "Stock Display" and replace all contents with:

Ref,Name,IsStockMonitored,Stocklevel,RawPrice
<actinic:block type="EntireSectionList"><actinic:block type="SectionEntireProductList"><actinic:block if="%3cactinic%3avariable%20name%3d%22ProductType%22%20%2f%3e%20%3d%3d%200" >
<br>"<actinic:variable name="ProductReference" encoding="perl" />","<actinic:block php="true">echo str_replace('"', '""', '<actinic:variable encoding="perl" selectable="false" name="ProductName" />');</actinic:block>",<actinic:variable name="IsStockMonitored" />,<actinic:variable name="StockLevel" />,<actinic:variable name="ProductPriceRaw" />
</actinic:block></actinic:block></actinic:block>

OK out, set a Fragment to use "Stock Display" as its layout, Preview it and copy / paste the displayed data to a file to use in a spreadsheet.

You'll get a list like:

Ref,Name,IsStockMonitored,Stocklevel,RawPrice
"47","Engagement Ring",0,0,240
"1","Three Diamond Ring",0,-10,20
"2","Wedding Rings",1,100,130
"3","Solitaire Diamond Ring",0,0,150
"23","Diamond Pendant",0,25,80
"24","Gold Chain",0,25,80
"123-45","Amethyst Heart Necklace",1,2,50
"26","Pearl Necklace",1,23,60
"20","Picture Frame Locket",0,25,25
"21","Golden Heart Locket",0,25,30
"22","Pearl Locket",0,25,35
"27","Men's Engraved 3"" Bracelet",1,25,30
"28","Multi Pearl Bracelet",0,-6,80

Edit the bit of code to add in other Variables if needed. Help / Variable Reference Guide will show what's available.

Thank you, I really appreciate the effort there. Will try to do the other option, However your suggestion could be very helpful in regards to other customised lists in the future. Thanks again

[Mantra]

You can use SellerDeck's list functionality to generate a custom report with only a few steps.
Go to Design / Library / Layouts / Fragments.
Right click "Text Left Of Image" and choose Copy.
Rename that copy to be "Stock Display".
Open "Stock Display" and replace all contents with:

Ref,Name,IsStockMonitored,Stocklevel,RawPrice
<actinic:block type="EntireSectionList"><actinic:block type="SectionEntireProductList"><actinic:block if="%3cactinic%3avariable%20name%3d%22ProductType%22%20%2f%3e%20%3d%3d%200" >
<br>"<actinic:variable name="ProductReference" encoding="perl" />","<actinic:block php="true">echo str_replace('"', '""', '<actinic:variable encoding="perl" selectable="false" name="ProductName" />');</actinic:block>",<actinic:variable name="IsStockMonitored" />,<actinic:variable name="StockLevel" />,<actinic:variable name="ProductPriceRaw" />
</actinic:block></actinic:block></actinic:block>

OK out, set a Fragment to use "Stock Display" as its layout, Preview it and copy / paste the displayed data to a file to use in a spreadsheet.

Thank you Norman, this is really useful guidance.

I set up the "Stock Display" Layout Fragment within the More Pages Brochure Page that is ticked "Hide on the Web Site" with the other sample guidance fragments so that the Stock Display List can be previewed with the More Pages Brochure Page - Hide on the Web Site unticked when needed for the contents to be copied to Notepad and save as a .csv file for opening in Excel.

The inclusion of the ProductPriceRaw variable should also be helpful to some users for batch price updates using Excel to import back into Sellerdeck with Price as text in the lowest currency denomination format (e.g. £5.47 = 547).

Martin