Menu
Feedback
Start here
Tutorials
Developer portal

Known Issues
Support Rules
Troubleshooting

Frequently Asked Questions
Announcements
Known issues
Subscription plan is 'stuck' in 'importing' after uploading the SKUs association spreadsheet
Subscription plan is 'stuck' in 'importing' after uploading the SKUs association spreadsheet
ID: 571080
Fixed
Published on 5/3/2022
Last update on 11/25/2022

Summary

It is important to note that the Plans section within the Subscriptions module is relatively new and is still in the Beta stage.

Within the Plans options for subscriptions, we have a functionality that allows you to import from an Excel spreadsheet all those SKUs that you want to associate with a specific plan.

For the import, the indicated base spreadsheet shows two columns with examples of the values that must be placed. In the first column the ID of the SKU and in the second the value defines whether or not this SKU is associated. Here is an example of how it is displayed:

{"base64":"  ","img":{"width":254,"height":86,"type":"png","mime":"image/png","wUnits":"px","hUnits":"px","length":4406,"url":"https://raw.githubusercontent.com/vtexdocs/help-center-content/refs/heads/main/docs/en/known-issues/Order%20Management/subscription-plan-is-stuck-in-importing-after-uploading-the-skus-association-spreadsheet_1.png"}}

In this case, the problem occurs because our service currently only accepts a numerical value in the "associate" column, that is, only 0 for false or 1 for true. When uploading the spreadsheet with text in the "associate" column, the plan will remain in the "importing" state indefinitely, which currently blocks the ability to edit or upload a new spreadsheet.

Simulation

To simulate it, you can:

  1. Upload the spreadsheet with the indicated text ("TRUE") in the "associate" column.
  2. Validate the status of the plan that will remain "importing".
  3. You can’t be able to edit the specific Plan.

Workaround

To avoid this behavior, it is recommended to upload the spreadsheet with the numerical format indicated (0 or 1) in the "associate" column and ensure that this cell is in fact in number format. Here is an example:

{"base64":"  ","img":{"width":252,"height":93,"type":"png","mime":"image/png","wUnits":"px","hUnits":"px","length":4036,"url":"https://raw.githubusercontent.com/vtexdocs/help-center-content/refs/heads/main/docs/en/known-issues/Order%20Management/subscription-plan-is-stuck-in-importing-after-uploading-the-skus-association-spreadsheet_2.png"}}

In case the plan is "blocked", the idea is that for the moment a ticket is opened for the Order Management team, to try to "unblock" the specific Plan.

Contributors
2
Photo of the contributor
Photo of the contributor
+ 2 contributors
Contributors
2
Photo of the contributor
Photo of the contributor
+ 2 contributors
On this page
Still got questions?
Ask the community
Find solutions and share ideas in the VTEX community.
Join our community
Request support from VTEX
For personalized assistance, contact our experts.
Open a support ticket
GithubDeveloper portalCommunityFeedback