I would like to know if it's possible to store shipment labels inside files rather than directly in a Magento 2 database.

The sales_shipment table contains a column called shipping_label, which is used to store the labels. These labels are stored as a compressed PDF string that generally starts with %PDF-1.4, and ends with %%EOF. This string is typically at least 100KB, and so as a result the table is over 7GB in size, is sluggish, and can sometimes crash the frontend of the website when viewing orders with a "MySQL has gone away" error. Furthermore, backups don't always work with it being so large.

If Magento were to instead save these as G-zipped files (or perhaps plain PDF files) and refer to these when required, then the size of the table will drop massively, and the speed will greatly increase.

Is there a way to tell Magento to do this? I've had a good web search but found nothing. Thank you!


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.