Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Exporting a Stock table does not include the "Stock value" column #6321

Closed
3 of 4 tasks
JambonLeVrai opened this issue Jan 22, 2024 · 7 comments · Fixed by #6911
Closed
3 of 4 tasks

Exporting a Stock table does not include the "Stock value" column #6321

JambonLeVrai opened this issue Jan 22, 2024 · 7 comments · Fixed by #6911
Labels
Fund This issue can be specifically funded for development import / export Data importing, exporting and processing inactive Indicates lack of activity question This is a question
Milestone

Comments

@JambonLeVrai
Copy link

JambonLeVrai commented Jan 22, 2024

Please verify that this bug has NOT been raised before.

  • I checked and didn't find a similar issue

Describe the bug*

The "Stock value" column, which is displayed when displaying the stock, is not exported when performing an export.

Steps to Reproduce

  1. Navigate to stock menu
  2. Click Download table data and download the data in any format
  3. Open and check the exported file

Expected behaviour

I would expect this column to be exported along with the rest. It seems pretty straightforward, since the export function exports pretty much all the info displayed on the table of the inventree frontend, that it would also export this column.
The "stock value" also includes some valuable information that cannot be obtained from the other columns, since it gives a value to a stock item even if it is not tied to a purchase order (and therefore does not have a purchase price) or if it is an assembly (where the value is computed from the components of the assembly).

Deployment Method

  • Docker
  • Bare metal

Version Information

Version Information:

InvenTree-Version: 0.13.3
Django Version: 3.2.23
Commit Hash: e81349e
Commit Date: 22/01/2024

Database: postgresql
Debug-Mode: False
Deployed using Docker: True
Platform: Linux-5.15.0-91-generic-x86_64-with
Installer: DOC

Active plugins: [{'name': 'InvenTreeBarcode', 'slug': 'inventreebarcode', 'version': '2.0.0'}, {'name': 'InvenTreeCoreNotificationsPlugin', 'slug': 'inventreecorenotificationsplugin', 'version': '1.0.0'}, {'name': 'InvenTreeCurrencyExchange', 'slug': 'inventreecurrencyexchange', 'version': '1.0.0'}, {'name': 'InvenTreeLabel', 'slug': 'inventreelabel', 'version': '1.0.0'}, {'name': 'InvenTreeLabelSheet', 'slug': 'inventreelabelsheet', 'version': '1.0.0'}, {'name': 'DigiKeyPlugin', 'slug': 'digikeyplugin', 'version': '1.0.0'}, {'name': 'LCSCPlugin', 'slug': 'lcscplugin', 'version': '1.0.0'}, {'name': 'MouserPlugin', 'slug': 'mouserplugin', 'version': '1.0.0'}, {'name': 'TMEPlugin', 'slug': 'tmeplugin', 'version': '1.0.0'}]

Please verify if you can reproduce this bug on the demo site.

  • I can reproduce this bug on the demo site.

Relevant log output

No response

Upvote & Fund

  • We're using Polar.sh so you can upvote and help fund this issue.
  • We receive the funding once the issue is completed & confirmed by you.
  • Thank you in advance for helping prioritize & fund our backlog.
Fund with Polar
@JambonLeVrai JambonLeVrai added bug Identifies a bug which needs to be addressed question This is a question triage:not-checked Item was not checked by the core team labels Jan 22, 2024
@SchrodingersGat
Copy link
Member

@JambonLeVrai can you please provide an example screenshot of the data you are looking to export here? I'm not sure exactly what you're asking for

@SchrodingersGat SchrodingersGat added import / export Data importing, exporting and processing and removed bug Identifies a bug which needs to be addressed triage:not-checked Item was not checked by the core team labels Jan 22, 2024
@JambonLeVrai
Copy link
Author

On the image, the column I am talking about is the one I framed in red :
image
And whenever the stock is exported (here I took .xlsx as an example) we get all those columns :
image
Where the stock value column is missing. In this example, on the second line there is no purchase price, because the stock wasn't tied to a purchase order, but is still valued thanks to the other pricings available in the database ; this is the information I would like to keep when exporting the stock.

@SchrodingersGat SchrodingersGat added the Fund This issue can be specifically funded for development label Jan 31, 2024
@SchrodingersGat
Copy link
Member

@JambonLeVrai I see what you are saying. This could be added in to the export feature. Would you be willing to sponsor this? There are a lot of other features on our development schedule :)

Copy link
Contributor

This issue seems stale. Please react to show this is still important.

@github-actions github-actions bot added the inactive Indicates lack of activity label Mar 31, 2024
@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Apr 7, 2024
@JackFGS
Copy link

JackFGS commented Apr 10, 2024

Not Stale

@SchrodingersGat
Copy link
Member

@JackFGS @JambonLeVrai if you guys want to see attention given to this, I suggest that you check out this issue.

The import / export framework is undergoing a major refactor which will allow us to support new features such as this. Is you would like to see this given priority you can sponsor either this issue or #3101

@SchrodingersGat SchrodingersGat added this to the horizon milestone Apr 10, 2024
This was referenced Apr 10, 2024
@SchrodingersGat
Copy link
Member

This is now implemented in #6911

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Fund This issue can be specifically funded for development import / export Data importing, exporting and processing inactive Indicates lack of activity question This is a question
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants